Hi all,
In the output sequential stage is there any method to remove the delimiters for certain rows....
Remove the delimiters
Moderators: chulett, rschirm, roy
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
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
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"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: