Field defaults Quotes In Sequential File stage

[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.

[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.

[Aquilis]

I got you.
Thank you ...

[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)

[ray.wurlod]

Are you setting Field Delimiter String property or Field Delimiter ?

[Aquilis]

No,am talking about Text qualifier. So used the property "quote".

Code: Select all

Format tab ---->Field Defaults------->Quote

[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.