DSXchange

Posted: **Tue Sep 28, 2010 1:15 pm**

Hi All ,

In Sequential stage , in the format tab if the values are set as

delimiter=comma and quote= double ,

ie; if I have files coming as csv without quotes and a
csv with quotes , can I have the properties set as above..

I tried reading for csv without quotes and csv with quotes and it read the file correctly ......but I just want to make sure or confirm if it is ok doing so?

Thank you all in advance.

Posted: **Tue Sep 28, 2010 1:44 pm**

CSV file without quotes and CSV with quotes will be read properly by using your format setting

Posted: **Tue Sep 28, 2010 1:50 pm**

anbu wrote:CSV file without quotes and CSV with quotes will be read properly by using your format setting

Thanks for your response anbu !

Posted: **Wed Sep 29, 2010 1:47 am**

anbu wrote:CSV file without quotes and CSV with quotes will be read properly by using your format setting

Anbu,

Isn't quote= double would affect the sequential file which is not having quotes?

if not, why

Posted: **Wed Sep 29, 2010 6:10 am**

No. It just means that if it does have quotes, they are doubles. It doesn't mean that quotes are in some way required to be in the file.

Posted: **Wed Sep 29, 2010 10:19 am**

chulett wrote:No. It just means that if it does have quotes, they are doubles. It doesn't mean that quotes are in some way required to be in the file. ...

Thanks Craig!!!

DSXchange

Sequential stage quote=double, how does that work?

Sequential stage quote=double, how does that work?