Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
kollurianu
Premium Member
Posts: 614 Joined: Fri Feb 06, 2004 3:59 pm
Post
by kollurianu » Tue Sep 28, 2010 1:15 pm
Hi All ,
In Sequential stage , in the format tab if the values are set as
delimiter=comma and quote= double ,
ie; if I have files coming as csv without quotes and a
csv with quotes , can I have the properties set as above..
I tried reading for csv without quotes and csv with quotes and it read the file correctly ......but I just want to make sure or confirm if it is ok doing so?
Thank you all in advance.
anbu
Premium Member
Posts: 596 Joined: Sat Feb 18, 2006 2:25 am
Location: india
Post
by anbu » Tue Sep 28, 2010 1:44 pm
CSV file without quotes and CSV with quotes will be read properly by using your format setting
You are the creator of your destiny - Swami Vivekananda
kollurianu
Premium Member
Posts: 614 Joined: Fri Feb 06, 2004 3:59 pm
Post
by kollurianu » Tue Sep 28, 2010 1:50 pm
anbu wrote: CSV file without quotes and CSV with quotes will be read properly by using your format setting
Thanks for your response anbu !
agpt
Participant
Posts: 151 Joined: Sun May 16, 2010 12:53 am
Post
by agpt » Wed Sep 29, 2010 1:47 am
anbu wrote: CSV file without quotes and CSV with quotes will be read properly by using your format setting
Anbu,
Isn't quote= double would affect the sequential file which is not having quotes?
if not, why
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Sep 29, 2010 6:10 am
No. It just means that if it does have quotes, they are doubles. It doesn't mean that quotes are in some way required to be in the file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
agpt
Participant
Posts: 151 Joined: Sun May 16, 2010 12:53 am
Post
by agpt » Wed Sep 29, 2010 10:19 am
chulett wrote: No. It just means that if it does have quotes, they are doubles. It doesn't mean that quotes are in some way required to be in the file. ...
Thanks Craig!!!