Hello Guys,
I have source with 2 columns,One is Account_No,second one is Account_Hold_Name.My requirement is need to data scrubbing/scrambling
data of first one(Account_No)
its not exactly Encrtpt and Decrypt.its data scrubbing/scrambling.
Example:
Account_No:ABC123456
We need to scrambling. the data like SR#*95471
For that we have write a logic.
A------>S
B-------.R
C------>#
1------->*
2------->9.......etc
can you please help me out this ?
Thnaks
VijayKumar-91-8806678186
data scrubbing/scrambling
Moderators: chulett, rschirm, roy
data scrubbing/scrambling
Abhinav
Code: Select all
Convert('ABC12','SR#*9',In.Account_No)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Masking is similar but involves still having 'useful' data when you are done, this seems to be just... scrambling.
Here is a fairly recent discussion on the subject.
![Wink :wink:](./images/smilies/icon_wink.gif)
Here is a fairly recent discussion on the subject.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers