View previous topic :: View next topic
|
Author |
Message |
anatol
Active User
Joined: 20 May 2010 Posts: 121 Location: canada
|
|
|
|
Hello,
I have file with users Last name ( position 1-10) First name ( position 11-21)
and second file, where in field positions 40 - 200 may be user Last name in any of this field position. Could you please give me idea to create output file where Last name from second file changed to the user first name. Output file should have only records from second file that was changed. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2022 Location: USA
|
|
|
|
Try to do something YOURSELF, then ask here for any advice.
This forum is not supposed to MAKE YOUR JOB instead of you. |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2022 Location: USA
|
|
|
|
anatol wrote: |
Could you please give me idea to create output file where Last name from second file changed to the user first name. |
The idea is, using the parameters PARSE=, and BUILD=
Another thing is - using SS to perform string comparison within varying positions. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
changing data in some dataset based on the content of another dataset
can be done easily enough with a JOINKEY operation
but JOINKEY needs the keys in a fixed position
since one of the keys is not in a FIXED position, the approach is impossible |
|
Back to top |
|
|
anatol
Active User
Joined: 20 May 2010 Posts: 121 Location: canada
|
|
|
|
Thank you all. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
You haven't told us clearly at first place as to what exactly is expected with sample data.
Do you need to match two DS and if last name from second ds= first name from first ds then write else skip? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
no need for any detailed description of the data
Quote: |
... where in field positions 40 - 200 may be user Last name in any of this field position. ...
|
that' s the show stopper for a joinkey solution |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2022 Location: USA
|
|
|
|
enrico-sorichetti wrote: |
but JOINKEY needs the keys in a fixed position
since one of the keys is not in a FIXED position, the approach is impossible |
Using PARSE=, and BUILD= before JOINKEYS may help with this approach, too.
Also other approaches are available. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
parse on what ? |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2022 Location: USA
|
|
|
|
enrico-sorichetti wrote: |
parse on what ? |
in field positions 40 - 200, using INREC for one of joined files before joining them |
|
Back to top |
|
|
anatol
Active User
Joined: 20 May 2010 Posts: 121 Location: canada
|
|
|
|
I've went other way ... from file1 ( Lastname Firstname) I've generated sort statements with FINDREP .... lastname to firstname name using
sqz, left, lead, trail,mid...
then for file2 I use those statements |
|
Back to top |
|
|
|