View previous topic :: View next topic
|
Author |
Message |
peeterparker
New User
Joined: 17 Nov 2006 Posts: 6
|
|
|
|
Hi,
I want to extract all the records in a file(of length 185) which contain 9 digit numbers starting at any location from 33 to 184. is this possible with any of the SORT utilities? Please help.
Thanks. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
When you have a question, start a new topic for your question rather than posting a reply to some existing topic.
It is best to include the recfm and lrecl as well. |
|
Back to top |
|
|
Garry Carroll
Senior Member
Joined: 08 May 2006 Posts: 1193 Location: Dublin, Ireland
|
|
|
|
Quote: |
which contain 9 digit numbers starting at any location from 33 to 184 |
This is a bit vague.
Can you tell us more about the records? Is it, say, a comma-delimited file? Is the field always 9 digits? What if there are 10 or more digits in the range? Is it (one of) a pre-defined (set of) numeric strings you want to base the selection on? RECFM and LRECL would also be helpful.
Garry. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
peeterparker,
Show an example of your input records (relevant fields only) for the variations you want to handle, and the expected output records. Explain the "rules" for getting from input to output. Give the RECFM and LRECL of the input file. Give the starting position, length and format of each relevant field. |
|
Back to top |
|
|
|