Tab Delimited file Delimited Value in the stage properties ?

[rxs0005]

I have a TAB delimited txt file that I saved using TOAD it has more than 65000rows so i cannot save it using .CSV extension how do i load this file using the flat file stage


Basically what will be the valus of the DELIMITER Box in the output / Format tab on the flat file stage properties.

for EG .CSV its , for TAB what do we fill that with .

thanks

rxs0005

[DSguru2B]

the ascii value for a tab is 009. Basically thats what goes in the delimiter box.

[chulett]

I have a TAB delimited txt file that I saved using TOAD it has more than 65000rows so i cannot save it using .CSV extension

Sure you can, there's no limit on the number of rows that can be in a csv file. Just don't try to load it into Excel...

[vmcburney]

Probably better to name it as a TSV file! Or a txt file. Calling it CSV is a bit misleading since it isn't comma seperated.

Import the file definition through the DataStage Manager and you will see tab delimited as one of the seperator options. This will also bring in the field names. Drag and drop the table definition onto your sequential file output link, this will drop both the column names and the file formatting into your sequential file stage! It will set it to tab delimited for you.

See my Developer Shortcut Tips for more info on this and other shortcuts.