Page 1 of 1

CSV support in parallel jobs

Posted: Tue Mar 11, 2008 5:17 am
by PhilHibbs
Parallel job Sequential File stage can't read or write CSV data. Specifically I mean the convention of doubling up the quote character if it occurs in the data, so this string:

Code: Select all

A rusty 6" nail
would be written out, just like a server job or Microsoft Excel would, as this:

Code: Select all

"A rusty 6"" nail"
Currently, it would be written out by a parallel job like this:

Code: Select all

"A rusty 6" nail"
and neither a server nor parallel job can read this back in again.

Posted: Tue Mar 11, 2008 5:20 am
by ArndW
That is a known issue, and there is a current thread on the same topic.

Posted: Tue Mar 11, 2008 5:40 am
by ray.wurlod
's right. It's Phil's thread. Obviously he's firing at the vendor with all available ammunition.

Posted: Tue Mar 11, 2008 5:59 am
by ArndW
Lol - I should have paid more attention :) I am fairly certain that I put this one in as eCase a couple of years back.

Posted: Tue Mar 11, 2008 7:08 am
by chulett
Yah... still trying to nail them with that rusty six inch nail, I see. :wink:

Posted: Tue Jun 17, 2008 3:10 am
by DSRajesh
Its still goes with the same issue either in server or parallel