Can i use .xls file as input stage in datastage.

nilesh · Post by **nilesh** » Wed Jul 11, 2007 2:52 am

Hi,

I am getting data in .xls format.I am converting it in .CSV format and loading it.But in CSV say in one column i am getting double comma's in one colmn so it gives me error.

Is there any other way round for this problem?

Thanks in advance.
Nilesh

ArndW · Post by **ArndW** » Wed Jul 11, 2007 3:05 am

When you convert your .xls into a .csv make sure that you quote all strings, then you won't get this problem.

kumar_s · Post by **kumar_s** » Wed Jul 11, 2007 4:51 am

Same time, the Sequential stage that is used to read those files need to be configured with proper delimieter and quotes. Integer fields doesn't expect a double qoute in it.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 11, 2007 9:21 am

Double comma indicates that the cell was empty. In the Columns definition right click on this particular column definition, choose Edit Row, and make the column nullable with a Null Field Value of "" (or a Null Field Length of 0).