|
View previous topic :: View next topic
|
| Author |
Message |
Squeak6
New User
Joined: 04 Aug 2005
Posts: 36
|
|
|
|
Good Morning all..
I have Last name in Col 66 legnth of 20 & first name in col 88 lengh of 19.. I'm trying to covert everything except the first letter of each to lower.. ( in those 2 fields ) I tryed using UTOL.. it worked but it removed all of my other fields.. ( I want my other fields just as they are )
this is what I did in my sysin
| Code: |
| OUTREC FIELDS=(66,19,TRAN=UTOL,89,18,TRAN=UTOL) |
all the other fields are gone this is what i get..
| Code: |
000001 oncrieffe ngel
000002 etancourt lcides |
|
|
| Back to top |
|
 |
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
Use....
| Code: |
| OUTREC OVERLAY=(66:66,19,TRAN=UTOL,89:89,18,TRAN=UTOL) |
|
|
| Back to top |
|
|
Squeak6
New User
Joined: 04 Aug 2005
Posts: 36
|
|
|
|
| I worked.. thank you.. |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Squeak6 wrote: |
| I worked.. thank you.. |
Cheers.. Below from DFSORT documentation will give you clear idea...
| Quote: |
BUILD or FIELDS: Reformat each record by specifying all of its items one by one. Build gives you complete control over the items you want in your reformatted OUTREC records and the order in which they appear. You can delete, rearrange and insert fields and constants. Example:
OUTREC BUILD=(1,20,C'ABC',26:5C'*',
15,3,PD,EDIT=(TTT.TT),21,30,80:X)
OVERLAY: Reformat each record by specifying just the items that overlay specific columns. Overlay lets you change specific existing columns without affecting the entire record. Example:
OUTREC OVERLAY=(45:45,8,TRAN=LTOU)
|
|
|
| Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
|
|
| Back to top |
|
|
|
|
