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.
Field defaults Quotes In Sequential File stage
Moderators: chulett, rschirm, roy
-
- 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:
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.
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.
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.
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...
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)
Aquilis
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No,am talking about Text qualifier. So used the property "quote".
Code: Select all
Format tab ---->Field Defaults------->Quote
Aquilis
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.