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
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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"
<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: