Page 1 of 1

comma (CSV) file for sources

Posted: Wed Feb 19, 2014 9:41 am
by lsnovick
I have all my sources coming in as csv.

I know how excel saves off the files as , and within the fields it uses ","

How can DS read these files correctly? I have searched this forum but can't find anything.

Thanks.

Posted: Wed Feb 19, 2014 10:18 am
by abhijitg
You can use a sequential file stage and define you delimiter as a comma. You might also want to check if quotes are required.

Posted: Wed Feb 19, 2014 10:28 am
by rkashyap
If comma is only used as delimiter and not part of data then you are ok. However if comma is both part of data and delimiter, then you definitely need data to be enclosed in quotes.