|
View previous topic :: View next topic
|
| Author |
Message |
abraralum
New User
Joined: 19 Dec 2010
Posts: 42
Location: Bangalore
|
|
|
|
Hi,
I have corrected the 6 characters of each file at position 1904 and 1910 of a FB file. Both files of same record length as 1950 and having same no.of records.This is based on conditin if space is found in any of 6 characters of these two columns. As a result 10 records are found with space and replaced with a value. The I/P file is having some 1 million records.
Now, I will have to compare my file- before correction and new file -with correction and show only the records which were having spaces are corrected.
I tried to do this with Super C, but want output in a different file. Please advice.. |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
JOINKEYS with whole record as key (if data is in ascending order) or appended sequence number as key,
With former, just use the match marker ?
With the latter, arrange a comparison of the two records stored in a REFORMAT record. |
|
| Back to top |
|
|
abraralum
New User
Joined: 19 Dec 2010
Posts: 42
Location: Bangalore
|
|
|
|
Bill,
Data is sorted, I am not clear about your question "With former, just use the match marker ? " |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
This is now a match of the data once fixed.
Simpler as a new topic, I think.
| Code: |
| JOIN UNPAIRED,F2,ONLY |
Is even simpler, assuming F2 is the "new" file, and with the key for the JOINKEYS being the entire record. |
|
| Back to top |
|
|
|
|
