Parse A Delimited String

ravenswood · Jan 29th 2007

I need to break out text into several fields. Here's a sample of what a typical record would look like...

~0926~Tst 6 Month Access~2~$500.00~$1000.00

Whats the best way to go about this? I'd like the end result to look like this:

Access Code = 0926
Desc = Tst 6 Month Access
Quantity = 2
Charge_Amt = $500
Tot_Charged = $1000.

By the way, I cannot import a delimited file because I had to apply code to get the record in the format you see above.

Thanks,

**norie** · Jan 29th 2007

Re: Parse A Delimited String

How about using Data>Text to columns... with ~ as the delimiter.

By the way what do you mean by 'cannot import a delimited file'.

charlesa920 · Jan 30th 2007

Re: Parse A Delimited String

If the value in the cell is the result of a formula, that is you can see the results in the cell but you see a formula in the formula bar...

You can do a copy and the paste it back in the same cells using "paste special" =values

Now the formula has been replaced by its returned value.

Participate now!