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
Transformation rule
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 2
- Joined: Sat Mar 11, 2006 8:13 am
- Contact:
Re: Transformation rule
Replace # with \n
-
- Participant
- Posts: 2
- Joined: Sat Mar 11, 2006 8:13 am
- Contact:
Re: Transformation rule
madhukar thanks for reply.
can u explain clearly.
can u explain clearly.
madhukar wrote:Replace # with \n
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>