Hi All,
How can we use 3 characters(@#$) as field delimiter while reading a text file using Sequential file stage either in server or parallel.
But, I checked the documentation and it says it will allow only one ASCII character.
Please shed some light on this.
Thanks in advance.
Delimiter
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No light to shed. The documentation is correct.
It can not be done in a Sequential File stage, unless that stage has a filter command to convert the three different delimiter characters to a consistent one.
Otherwise read each line from the file as a single string (for example if you need to preserve the actual delimiter characters) and parse in a downstream Transformer stage.
It can not be done in a Sequential File stage, unless that stage has a filter command to convert the three different delimiter characters to a consistent one.
Otherwise read each line from the file as a single string (for example if you need to preserve the actual delimiter characters) and parse in a downstream Transformer stage.
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.
