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.