I'm looking to parse my input file which is an unformatted .csv file and produce a formatted .csv file. Can you please guide how do I locate the presence of a comma and move the parsed data to relevant variables ?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
I'm not sure what you mean by "unformatted" - csv is a format.
If you mean that the position of data in your input is not constant, you should be able to do what you want with UNSTRING. Make sure you define the individual target fields large enough. My preference is to make them all character fields (pic x). Once you have the data broken into component pieces, you can then work with the individual fields to validate, reformat, etc before creating the new "formatted" data.