Page 1 of 1
Posted: Sat Nov 27, 2010 3:29 pm
by ray.wurlod
You can use strings longer than one character, but you have to use Field/Record Delimiter String property rather than Field/Record Delimiter (which is limited to a single character).
There is no default for these. The default is to use Field Delimiter = comma.
Posted: Wed Dec 01, 2010 1:45 am
by ray.wurlod
You're correct - I misunderstood your question.
Quote is, as far as I am aware, limited to a single character, though this can be any single character.
You may need to read your file with Quote=none, then strip the multi-character quotes in a subsequent stage, such as a Transformer.
This is a very unusual situation. Maybe you could request the data provider to provide a more conventionally quoted structure.
Posted: Fri Dec 03, 2010 5:34 am
by Aquilis
I got you.
Thank you ...
Posted: Thu Dec 23, 2010 1:29 pm
by Aquilis
After long time,I gave an another try on this. Found some new behavior which might be new to me but not for others.
Well that is:
Quotes can be of 2 characters (say: "$~") but Datastage is treats "$" as opening character & simultameously "~" as closing character.
Please comment, is that the way it should work...
Code: Select all
for example:
$~Hello Hello$~ ---------> ~Hello Hello$
( In File) (after Reading in DS)
Posted: Thu Dec 23, 2010 3:40 pm
by ray.wurlod
Are you setting Field Delimiter String property or Field Delimiter ?
Posted: Fri Jan 14, 2011 12:44 am
by Aquilis
No,am talking about Text qualifier. So used the property "quote".
Code: Select all
Format tab ---->Field Defaults------->Quote
Posted: Fri Jan 14, 2011 2:43 am
by ray.wurlod
Yes, multiple quote characters are treated as alternates, rather than as a single "quote" designator. Read your data unquoted and clean up subsequently, or get the data provider to supply data that conform to one of the industry standards, such as CSV.