I have a tab delimited sequential File. I would like to use this file in Transformation.
And I dont know how to enter the delimiter char (tab) in the delimiter box. Please help.
How to use Tab Delimiter in New Job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 2
- Joined: Thu Oct 26, 2006 2:17 am
- Location: India
In some places where you cannot click on a "tab" selector you can use the 3 digit numeric representation of 009.
What type of job and what stage and place within that stage are you referring to?
What type of job and what stage and place within that stage are you referring to?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 2
- Joined: Thu Oct 26, 2006 2:17 am
- Location: India
then change the delimiter in the designer Sequential stage tab for "format" to use comma and you will be all set.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you had specified tab when importing the table definition for the text file, all you need to do is click Load... on the Format tab in your Sequential File stage. The metadata are then loaded from the Repository. Tab will appear as a little black rectangle, but will work.
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.
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse