Hi
I have a comma delimited file.I have data as below
ab,cd,-Col1
dfg-col2
Since its comma delimted cd is assigned to col2.Please let me know how to avoid
Thanks
Comma delimited file
Moderators: chulett, rschirm, roy
Re: Comma delimited file
Hi Ush,
Actually, your question is not clear. But as per my understanding, you meant that you need to have the col1 as "ab,cd" , which is a concatenation of 2 cols.
To resolve this,you can read the delimited file with Comma specified as delimiter, and then you can concatenate the col1 and col2 later in next stage.
Regards,
Madhuri.
Actually, your question is not clear. But as per my understanding, you meant that you need to have the col1 as "ab,cd" , which is a concatenation of 2 cols.
To resolve this,you can read the delimited file with Comma specified as delimiter, and then you can concatenate the col1 and col2 later in next stage.
Regards,
Madhuri.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are rules about commas in data in comma-delimiited files. You can read about them in any product (such as Excel) that generates them. What you have is not a legally-formatted comma-delimited-format file.
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.