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