|
View previous topic :: View next topic
|
| Author |
Message |
abraralum
New User
Joined: 19 Dec 2010
Posts: 42
Location: Bangalore
|
|
|
|
Hi,
I have input as below:
123456fg-5678
678953hn6789
123456jk6789
234567yh-8906
Output should be:
123456fg-5678
678953hi 6789
123456jk 6789
234567jj-8906
A space to be inserted if sign is not given.
Please can any one guide me how to achieve this using sort.. |
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Assuming the output you show is incorrect and you really want positions 1-8 to remain the same, you can use the following DFSORT control statements to do what you want:
| Code: |
OPTION COPY
INREC OVERLAY=(9:9,5,SFF,EDIT=(STTTT),SIGNS=(,-))
|
The output would be:
| Code: |
123456fg-5678
678953hn 6789
123456jk 6789
234567yh-8906
|
If that's not what you want, then explain more clearly what you do want with a better example. |
|
| Back to top |
|
|
abraralum
New User
Joined: 19 Dec 2010
Posts: 42
Location: Bangalore
|
|
|
|
Thanks Frank... Actually I am doing testing for which I need to format the file like this.
Just afraid when can I write code so easily like you  |
|
| Back to top |
|
|
|
|
