How to read a file having record delmiter as blank line

[bgs_vb]

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 .

[swarnkar]

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

[ray.wurlod]

Search DSXchange for "vertical pivot", for this is what you are trying to accomplish.