Hi ,
I am getting input data as follow in a sequential file:
a: test us,osjkjkj
b: ab
c: defhj
a: tes1t usa,osjkjkj
b: cd
a: tt usa,osjkjkj
b: ef
c: ghij
d: defhj
Required output format is :
a|b|c|d
test us,osjkjkj|ab|defhj|NULL
tes1t usa,osjkjkj|cd|NULL|NULL
tt usa,osjkjkj| ef|ghij| defhj
Note: a,b,c,d are column names
I am not sure how to achieve this result . Please advise which stage i can use to achieve this in datastage .
How to read a file having record delmiter as blank line
Moderators: chulett, rschirm, roy
Re: How to read a file having record delmiter as blank line
You can pass your source file through a simple script where you can replace enter character with comma or some other delimiter and then
blank lines with enter chacter and change.
Thanks,
Nitin Swarnkar
blank lines with enter chacter and change.
Thanks,
Nitin Swarnkar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: