comma (CSV) file for sources

lsnovick · Post by **lsnovick** » Wed Feb 19, 2014 9:41 am

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.

abhijitg · Post by **abhijitg** » Wed Feb 19, 2014 10:18 am

You can use a sequential file stage and define you delimiter as a comma. You might also want to check if quotes are required.

rkashyap · Post by **rkashyap** » Wed Feb 19, 2014 10:28 am

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.