Page 1 of 1

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

Posted: Thu Mar 19, 2009 5:55 am
by cbhutani2
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.

Posted: Thu Mar 19, 2009 7:15 am
by Sainath.Srinivasan
It is in the delimiter property.

Posted: Fri Mar 20, 2009 5:30 am
by vjonnala1516
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 ","