Transformation rule

[kiran kumar dasari]

I have text file like

Input
-----
110#1101#1201#101#103
115#113#409#10543#
114
116#121#230#112
301#112
314#551#
123#154#121#183#1209

output
------
110
1101
1201
101
103
115
113
409
10543
114
116
121
230
112
301
112
314
551
123
154
121
183
1209


can any one help me, how to get these results through datastage parllel jobs


Thanks in advance

Kiran

[madhukar]

Replace # with \n

[kiran kumar dasari]

madhukar thanks for reply.
can u explain clearly.

Replace # with \n

[ArndW]

A single transform, declare your input as a single column and then do a CONVERT('#',CHAR(10),In.Column) and write it to a sequential file. This will convert each '#' character to a \n on output.