Extract data between two symbols

G

GrowlJones

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.
 
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
 
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...
 
Back
Top