Remove the delimiters

parvathi · Post by **parvathi** » Mon Sep 04, 2006 4:58 am

Hi all,
In the output sequential stage is there any method to remove the delimiters for certain rows....

ArndW · Post by **ArndW** » Mon Sep 04, 2006 5:11 am

The sequential stage delimiter definitions are for the whole file. If you need to do this you are best served by creating the file without any delimiters at all and using a transform stage to put them in manually for those rows where you need them.

chulett · Post by **chulett** » Mon Sep 04, 2006 6:50 am

You might want to explain your question a little better, possilby even post an example. Which 'delimiters' are you asking about?

Indra · Post by **Indra** » Mon Sep 04, 2006 7:07 am

I have a similar pbm

The i/p looks like
BEGIN HEADER CharacterSet "CP1252"
ExportingTool "Ascential DataStage Export"
ToolVersion "4"
MDISVersion "1.0"
Date "2006-09-01"
Time "11.51.45"
ServerVersion "7.5.1"
END HEADER

i have " as my delimiter.now the o/p looks like
BEGIN HEADER""
CharacterSet "CP1252"
ExportingTool "Ascential DataStage Export"
ToolVersion "4"
MDISVersion "1.0"
Date "2006-09-01"
Time "11.51.45"
ServerVersion "7.5.1"
END HEADER""

i have to remove the delimiter that appears after the begin header and end header.

How can i change so...

Thankx

ArndW · Post by **ArndW** » Mon Sep 04, 2006 7:15 am

Why not declare your output to have no delimiters, then in a transform check if the line begins with "BEGIN HEADER" or "END HEADER" and perform the appropriate string function. Or keep it as 2 column, but in a transform change the text BEGIN HEADER CharacterSet "CP1252" to BEGIN HEADER "CharacterSet CP1252"

ray.wurlod · Post by **ray.wurlod** » Mon Sep 04, 2006 9:18 pm

DataStage is an ETL tool. It is NOT a metadata manipulation tool. Get MetaStage if you want to play with metadata.