|
View previous topic :: View next topic
|
| Author |
Message |
sundeepthota
New User
Joined: 25 Mar 2008
Posts: 3
Location: Hyderabad, India
|
|
|
|
I have a file in which there is client name and Address. I would like to change name and addresses to something that is un recognizable. I would like sort to be used when the record has "Social Security" on it, at position 186. The data looks as below.
| Code: |
First Name starts at 220 column
\/
Y
DTarget Date - 2005 100%
TTotal 100%
Y..............................
Social Security Number:XXX-XX-XXXX FIRST NAME1 LAST NAME 2
Y
DTarget Date - 2010 100%
TTotal 100%
Y..............................
Social Security Number:XXX-XX-XXXX FIRST NAME2 LAST NAME 2
|
I have seen ALTSEQ and IFTHEN but not sure how to use those in this case. Any help would be much appreciated. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Your topic is about names & addresses but you don't show them. . .
What you want to do will probably not be done with ALTSEQ or IFTHEN. . .
How big is the dataset you want to "scrub"? How many different names & addresses?
This has been asked before and there should be some topics in the forum. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| You identify the lines to change with IFTHEN. You blat the name and address. How you want to blat them, you haven't said. Remember, if it is reversible, it is no use at all. Why are you not treating the SSN in the same way? |
|
| Back to top |
|
|
sundeepthota
New User
Joined: 25 Mar 2008
Posts: 3
Location: Hyderabad, India
|
|
|
|
The name and address are on the same line one after the other.
The file has close to 3 million records overall its a VB file.
I need to scrub SSN, Name and Address file so that the Name is not recognizable. I need to do the same with SSN and adress as well, but figured that if someone can give me a solution for Name, i can extrapolate that to other fields. I dont have to trace it back.
I am wondering if the below code might work.
| Code: |
SORT FIELDS=COPY
ALTSEQ CODE=(C1E9,D3E9)
INREC IFTHEN=(WHEN=(186,6,CH,EQ,C'SOCIAL'),
BUILD=(1,219,220,30,TRAN=ALTSEQ,250,30)) |
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| The file has close to 3 million records overall its a VB file. |
Which is why i believe IFTHEN will not work for you. . .
| Quote: |
| I am wondering if the below code might work. |
I do not believe the code will do what you want.
Please explain just how much you want the name scrambled. Show a few sample names and how you want them to be after your process. |
|
| Back to top |
|
|
sundeepthota
New User
Joined: 25 Mar 2008
Posts: 3
Location: Hyderabad, India
|
|
|
|
Hello,
Thanks for your response
I am good with scrambling the name few characters. i.e
Replacing A with Z
Replacing E with Y
Replacing I with X
Replacing O with V
Sandy Marcelas - > Szndy Mzrcylzs
Ingrid bergman - > XngrXd ByrgmzN
Can you help me out on this? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
If that little amount of scrambling is acceptable, the ALTSEQ might suffice. Your people understand that all of the names will be easily readable this way. . .
What about addresses and social security numbers?
Will there be data from other sources that need to "match" with these jumbled values? |
|
| Back to top |
|
|
|
|
