View previous topic :: View next topic
|
Author |
Message |
arien
New User
Joined: 02 Nov 2006 Posts: 43 Location: London
|
|
|
|
Hi all,
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 ?
Thanks,
Arien. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
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. |
|
Back to top |
|
|
arien
New User
Joined: 02 Nov 2006 Posts: 43 Location: London
|
|
|
|
Hello DS,
You've got the question right and Unstring is working perfectly fine for my case. Thank you.
cheers,
Arien |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome - good to hear it is working
d |
|
Back to top |
|
|
|