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