Extracting Quantity

[CHuguley]

I want to be able to extract the quantity (the number before the comma) and amount (the numbers after the comma. The info is downloaded from a mainframe system in a text file. Example:

,00000000000000004.0000,0000000000040.00,

I want to be able to strip out 4.0 for quantity and 40.00 for amount. Utilizing the left and right functions will take forever. Any help would be greatly appreciated.

 

[AJ]

How about just using Data>Text to columns , with comma as the delimiter? Then format the two columns you'll be left with as you want.

Rgds
Alex