problem with double quotes

IBMDS · Post by **IBMDS** » Fri Mar 28, 2008 1:39 pm

I am extracting data from comma and quote separted sequential file.

for some of records the format like this and these records are dropped because of the following warning

sff_XYZ,0: Field "XYZ_IND" has import error and no default value; data: {1 1 1 1 1 1 1 1 1 1}, at offset: 90

I verified the data one particular column its self getting value like this

0,0,0,"IBMDS "DSX"",0,0,0,"ABCD"

we need to treat IBMDS DSX as one value. but its DSX taking for next column.

Thanks

samba · Post by **samba** » Fri Mar 28, 2008 1:55 pm

search for 'double quotes' in dsxchange.

Thanks
samba

girija · Post by **girija** » Fri Mar 28, 2008 2:06 pm

samba wrote:search for 'double quotes' in dsxchange.

Thanks
samba

So your field separator is , (comma) and data contains " (quote).
Try this ....
Set field separator as ,
and quote as none in the properties tab.