| View previous topic :: View next topic |
| Author |
Message |
rajkumar_1981
Beginner
Joined: 05 Jan 2007
Posts: 5
Topics: 4
|
 Posted: Thu Feb 14, 2008 6:17 am Post subject: truncating leading spaces. |
 |
|
hi,
input file
field lenght is 50.
| Code: |
1............................................................50
adf dfdf fdfeff fd
adf dfddf
adfdfd
adfdf
dfsdfa
adfsdfa
a |
output file | Code: |
1............................................................50
adf dfdf fdfeff fd
adf dfddf
adfdfd
adfdf
dfsdfa
adfsdfa
a
|
i want truncate all leading space from input file. i want to place the data from 1st starting position in the output file.
any utilities is there?
no program to be written for this. only utilities to be used.
please reply for the above query |
|
| Back to top |
|
 |
vkphani
Intermediate
Joined: 05 Sep 2003
Posts: 483
Topics: 48
|
| Posted: Thu Feb 14, 2008 7:01 am Post subject: |
|
|
Do not open multiple threads on same topic.
You can use the below sort card.
| Code: |
//SYSIN DD *
OPTION COPY
INREC OVERLAY=(1,80,SQZ=(SHIFT=LEFT,MID=C' '))
/*
|
|
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Thu Feb 14, 2008 11:39 am Post subject: |
|
|
SQZ would not give the correct solution in this case since it would squeeze out multiple blanks between fields and replace them with only one blank. For example,
would be output as:
JFY is the correct function to use in this case.
Here's a DFSORT job that will actually do what was requested:
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file (FB/50)
//SORTOUT DD DSN=... output file (FB/50)
//SYSIN DD *
OPTION COPY
INREC OVERLAY=(1,50,JFY=(SHIFT=LEFT))
/*
|
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
| Back to top |
|
|
mf_user
Intermediate
Joined: 01 Jun 2003
Posts: 372
Topics: 105
|
| Posted: Thu Mar 06, 2008 8:11 am Post subject: syncsort solution please? |
|
|
Hi,
Would you please suggest syncsort solution for this trick?
TIA.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
== |
|
| Back to top |
|
|
amargulies
Beginner
Joined: 10 Jan 2007
Posts: 123
Topics: 0
|
| Posted: Thu Mar 06, 2008 11:01 am Post subject: |
|
|
MF,
Franks solution will work with SyncSort for z/OS 1.3.
_________________
Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com |
|
| Back to top |
|
|
hari108
Beginner
Joined: 03 Feb 2006
Posts: 16
Topics: 4
|
| Posted: Fri Oct 10, 2008 1:37 am Post subject: |
|
|
| amargulies wrote: | MF,
Franks solution will work with SyncSort for z/OS 1.3. |
Alissa,
Do we have any solution with SynSort for what Frank has suggested using DFSORT?
If so please let me know.
_________________
Thanks,
Hari |
|
| Back to top |
|
|
expat
Intermediate
Joined: 01 Mar 2007
Posts: 475
Topics: 9
Location: Welsh Wales
|
| Posted: Fri Oct 10, 2008 4:23 am Post subject: |
|
|
Errrrrrr, did not Alissa answer your question ?
Please read her reply very carefully and if you have further questions please post them.
_________________
If it's true that we are here to help others,
then what exactly are the others here for ? |
|
| Back to top |
|
|
hari108
Beginner
Joined: 03 Feb 2006
Posts: 16
Topics: 4
|
| Posted: Wed Oct 15, 2008 12:23 am Post subject: |
|
|
Oops!! My mistake...I'm really Sorry 
_________________
Thanks,
Hari |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
