not abl to read flatfile with quote as double

datastagedw · Post by **datastagedw** » Wed Mar 12, 2008 5:41 am

i have the sample coming as follows:

"abc", "this is ""pick it up"" and check", "def"

now i want the output in viewdata as follows
abc, this is "pick it up" def

instead this is getting rejected when reading with SFS.

what delimiter string i should use? shall i use "," . i tried this also.
following are the settings i have:
quote=double

pls help

chulett · Post by **chulett** » Wed Mar 12, 2008 7:17 am

There are a couple of recent threads on this very topic, perhaps some of the principles from them could summarize the options here?

viewtopic.php?t=117173

viewtopic.php?t=117096

ray.wurlod · Post by **ray.wurlod** » Wed Mar 12, 2008 5:32 pm

Use None as the quote character in your target Sequential File stage. This is how you tell DataStage to use no quote characters surrounding strings.

chulett · Post by **chulett** » Wed Mar 12, 2008 7:21 pm

I believe they are trying to read data in the format, not write it, hence the links to the other recent topics on same.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 12, 2008 7:52 pm

Yes, if you set the quote character to None you get all the quote characters into your job where you can do something about it, rather than have the Sequential File stage spit the dummy.