DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
kunal1101
Participant



Joined: 03 Dec 2007
Posts: 8
Location: Pune
Points: 52

Post Posted: Wed Jan 16, 2008 6:02 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: TX
OS: Windows
Hi everyone....I am comparitively new to DSTX.
My doubt is,how can i change the input delimiter of data in output file?
for ex:-
if my data is:-
ABCWIDGET~A123~ABC Widgets (Delimiter ~)

and i want ouput data as:-
ABCWIDGET A123 ABC Widgets (Delimiter space)

how can i achieve this using single type tree?

_________________
Kunal_devil!!!
jvmerc
Participant



Joined: 02 Dec 2003
Posts: 94

Points: 812

Post Posted: Wed Jan 16, 2008 8:34 am Reply with quote    Back to top    

Several ways to handle this....

One is to copy your output record so you have record_in and record_out. Then file_in, file_out. Change the second records delimiter. Both records share the same elements with dif delimiters. The problem here is that if you change one record (add/remove element) you need to change both records.

Another way depends on your input data. If your first element is a fixed length you can define a variable delimiter.

Of course if all you want to do is change the delimiter you could define your records as text_blobs and substitute '~' with '<SP>'.

I'm sure there are other ways as well.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours