Extract data between two symbols

Joined
Jul 30, 2008
Messages
4
Reaction score
0
This might be simple but I really am struggling with this one...I need to extract specific data from a one cell mess of gibberish.

Basically it looks like sorta like this:

(00KL999130**404.49*412.7 5*-8.26\REF*DT*00A47;61\REF*VI*9042S131781\DTM*003*205812710\RJR*IV* 1234501010* *32706\REF*DT*0012587\REF*IR*904JK31781\DFM*063*22457618\RLR*IV* 0004501013** -184\REF*DT*F541497\REF*VR*9042S1L1781\WTM*007*202356618\SE*22*119793547\GM*1*67)

Now I know I want all numbers between double asterisks and a backslash (404.49*412.75*-8.26 would be the first instance in this example). Is it possible to create a formula to search and extract all data between those symbols and then loop so as to catch all instances within that cell?

Any advice would be HUGE. Thanks.
 
Joined
Jul 30, 2008
Messages
4
Reaction score
0
Okay I've been searching around the net and came up with something like this...

=IF(ISERROR(FIND("/",C1)),"",IF(ISERROR(FIND("**",C1)),"",LEFT(RIGHT(C1,LEN(C1)-FIND("**",C1)),
FIND("/",RIGHT(C1,LEN(C1)-FIND("**",C1)))-1)))

However I deperately need someway to make this loop in order to catch every possible instance.
And if possbile make it so that each number returned would appear in successive rows.

If any of the experts out there has any suggestions it would be great!

Thanks
 
Joined
Jul 30, 2008
Messages
4
Reaction score
0
This is still an active issue I'm trying to solve. Is there anyone out there with a better resolution to this problem?

I would really appreciate any help on this one...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top