1) To split CSV character-type fields by separators you need to use PARSE=…,BUILD=… parameters in either INREC/OUTREC/OUTFIL statements. The separator used instead of "comma" must be specified in ENDBEFR=C'|' and/or other separators.
2) More complicated case is, parsing numeric values with variable decimal point position. A special PARSE/BUILD combination is needed with ENDBEFR=C'.' parameter, in order to split actual whole/fractional parts of the numeric value. The provided SORT formats ZD/UFF/SFF cannot detect decimal point position.
Unfortunately, none of SORT manuals give any clue on how to parse flexible numeric values with variable decimal point position, but there are examples of similar operations in this forum.
********************************* TOP OF DATA ******
00123 ABC 00001250
12345 ABC 00011250
00001 ABC 00000250
******************************** BOTTOM OF DATA ****
I want to convert a variable length file that does not have ‘fixed’ columns lengths and also has a non-fixed decimal.
If you could have done Google and did some Research then you would have got many links and solutions to convert CSV (VB ) Data to FB including Decimals.
e.g.
Use [URL] BBCode for Links
