Sequential stage quote=double, how does that work?

kollurianu · Post by **kollurianu** » 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.

anbu · Post by **anbu** » Tue Sep 28, 2010 1:44 pm

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

kollurianu · Post by **kollurianu** » 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 !

agpt · Post by **agpt** » 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

chulett · Post by **chulett** » 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.

agpt · Post by **agpt** » 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!!!