Hi ,
I've got a comma separated file with character fields quoted with "s.
I've found some records where there is a section within a character field that is quoted with 2 double quotes.
e.g.
1,"some field1","some field with a ""quoted section"" in it",2
This seems to cause my datastage to assume that its a new field when it sees the "" characters.
Anyone got any ideas how I should handle that ?
Why does datastage treat the " character as though it signifies a new field ( when the file is using comma as the delimiter).?
Quote character within a quoted text field
Moderators: chulett, rschirm, roy
A good plan, but I've got to use our 'standard' jobs. (We've got a generic bit of px code to take any file and load it into a table with the same format).
I think I might stick a unix script with a sed command to remove "" from the file...unless anyone's got any other ideas.
Is there anything that can be set in the orchestrate schema definition for the input file layout which would handle these double quotes?
I think I might stick a unix script with a sed command to remove "" from the file...unless anyone's got any other ideas.
Is there anything that can be set in the orchestrate schema definition for the input file layout which would handle these double quotes?
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
That won't help, it's not the field delimiter that's the issue, it's the fact that string fields are double-quoted and then have them inside as well. You could try removing that property from the field and then trim the quotes from inside the job, I would think.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: