View previous topic :: View next topic |
Author |
Message |
klohandansub Beginner
Joined: 17 Sep 2003 Posts: 1 Topics: 1
|
Posted: Wed Sep 17, 2003 1:10 am Post subject: how to find comp -3 variables. |
|
|
a file contains a list of records with different datatypes.Along with them are some records of comp -3 type.While reading that file,I need to find and pick the only the records that are comp -3.on what basis would i be able to pick them ? |
|
Back to top |
|
|
Cogito-Ergo-Sum Advanced
Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
|
Posted: Wed Sep 17, 2003 4:29 am Post subject: |
|
|
kloh,
Can you show the input layout please? Never mind the PD field. Let it appear as it appears in the browse. _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes. |
|
Back to top |
|
|
Dibakar Advanced
Joined: 02 Dec 2002 Posts: 700 Topics: 63 Location: USA
|
Posted: Wed Sep 17, 2003 5:59 am Post subject: |
|
|
I guess standard requirement would be to give examples of input output.
One guess- If you can open the file in edit mode then
Code: |
"c all p'@' ''" will remove all alphabetic characters
"c all p'#' ''" will remove all numeric characters
"c all p'$' ''" will remove all special characters
"c all p' ' ''" will remove all blank characters
|
See what you are left with after this.
Diba. |
|
Back to top |
|
|
slade Intermediate
Joined: 07 Feb 2003 Posts: 266 Topics: 1 Location: Edison, NJ USA
|
Posted: Wed Sep 17, 2003 12:29 pm Post subject: |
|
|
Hi Klo,
I don't think you can ID comp-3 fields w/any degree of certainty. To wit:
The string X'0201591C' can represent a comp-3 field +02015911 or it can represent 2 fields: a comp +513 and a comp-3 +5911 or a comp +2102673 and an A/N "A".
regards, Jack. |
|
Back to top |
|
|
slade Intermediate
Joined: 07 Feb 2003 Posts: 266 Topics: 1 Location: Edison, NJ USA
|
Posted: Fri Sep 19, 2003 9:47 am Post subject: |
|
|
Not that this matters to Klohandansub, but to anyone else reading the thread I'd like to point out an error in my presentation.
The Hex string represented by +2102673 in my example should be 4 bytes, not 3 as represented, i.e. it should be X'00020159'.
However, the point I attempted to make is unchanged.
My apologies, Jack. |
|
Back to top |
|
|
|
|