DSXchange

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

i do not understand what is your problem. Please describe it more clearly.

I have comma delimited file.The data for col1 has comma in between i.e ab,cd
Data for col2 is dfg.

since its comma delimited,cd is assigned to col2 instead of dfg.My requirement is ab,cd should go to col1.

Thanks

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.

Sorry if I was not clear

I have 2 cols Subject Empid
Subject has the data :Arun,Hi
Empid:1233

File is as below:
Arun,Hi,1233

When I load Arun gets into subject hi gets into Empid...

Thanks

use the optioin Quotes: double and the data file should be like this...

Data File :
"Arun,Hi","1233"

then Arun,Hi will get into subject and 1233 will go into empid

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.