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
not abl to read flatfile with quote as double
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 53
- Joined: Fri Mar 07, 2008 1:17 am
not abl to read flatfile with quote as double
ETL DEVELOPER
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
viewtopic.php?t=117173
viewtopic.php?t=117096
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.