Hi,
I have double quotes in data and ds is not recognizing the field
Data looks like this
xxx,yyy,"last,first", "yyyy""",jjj
This is a .csv file and I have given the quote character as double quote.
This record is not being read in sequential file at all, so If I could read this I can strip the extra double quotes inside datastage.
Thanks!!
double quotes in data
Moderators: chulett, rschirm, roy
You might want to consider using a Server job for this, they are typically much more forgiving when it comes to reading files of this nature. That or leverage the Server Sequential File stage in a Server Shared Container in your PX job.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers