How to read excel file in csv format using sequential file?

cbhutani2 · Post by **cbhutani2** » Thu Mar 19, 2009 5:55 am

Hi,
I have my input source file in csv format, and I want to read it using sequential file. But, I cannot see any settings or property or format tab where I can select '.csv' so that I can specify that my input file is in csv format?
How can I read this file using a sequential file stage?

Regards,
Sumati.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 19, 2009 7:15 am

It is in the delimiter property.

vjonnala1516 · Post by **vjonnala1516** » Fri Mar 20, 2009 5:30 am

Saving the file in CSV format--open the XLS file and Goto FILE tab and then select Save As and then change the SAVE AS TYPE from XLS to CSV.

Reading the CSV file: Just mention the delimeter as ","