Hi
I am using a server job. I need to read a file that is comma seperated, but the data in one of the field contains comma. The data is not quoted. datastage interprets this comma as a delimiter and is not readin the data properly. How to overcome this?
CSV files- Read Problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Get "them" to supply you with a valid CSV file would be favourite. Commas within data require that character strings be quoted.
Otherwise you're going to have to specify something else as field delimiter - something not in the data at all - and effect your own parsing in a Transformer stage.
Otherwise you're going to have to specify something else as field delimiter - something not in the data at all - and effect your own parsing in a Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.