How to use Tab Delimiter in New Job

rahulunlimited · Post by **rahulunlimited** » Thu Oct 26, 2006 4:08 am

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.

srividya · Post by **srividya** » Thu Oct 26, 2006 4:34 am

Can you eloborate your question......its not clear on what you want to do .......

ArndW · Post by **ArndW** » Thu Oct 26, 2006 5:21 am

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?

rahulunlimited · Post by **rahulunlimited** » Thu Oct 26, 2006 5:53 am

I am doing a simple transformation of file from one location to another and in the target file, I do not want tab delimiter, instead I would prefer a comma delimiter.

ArndW · Post by **ArndW** » Thu Oct 26, 2006 6:03 am

then change the delimiter in the designer Sequential stage tab for "format" to use comma and you will be all set.

srividya · Post by **srividya** » Thu Oct 26, 2006 6:20 am

yep.....its a straight forward mapping. In the source file in delimeter select 'tab'........map it to a sequential file with the delimeter set to comma......

ray.wurlod · Post by **ray.wurlod** » Thu Oct 26, 2006 8:58 am

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.

samsuf2002 · Post by **samsuf2002** » Fri Oct 27, 2006 3:01 pm

its better to format the file while loading hte meta data delimiter can be selected from drop down , check box or manually