CODEWITHSUNDEEP
vbams-accessms-office
Dinesh M
Dinesh M

Reputation: 27

select block of text, right click and change it to something else like *****

I have some loosely formatted text in a database field. I need a tool (any language even sql will do) to transform certain portions of the field to xxxxx or *****.

e.g. Say the content of the field is - "I am trying to get something done. My Email is [email protected]. Address is - 123 Mnop Street, New York, NY, 10010. Phone: 1-212-325-0342"

Now, I need a way to change this to - "I am trying to get something done. My Email is [email protected]. Address is - 1XX MXXX StXXXX, NXX YXXX, NY, 1XXXX. Phone: 1-XXX-XXX-XXXX"

I'm thinking that since the data is not highly structured, the best way to do this will be on the front end in some editor by using a macro or something like that. The user will select the text they want to distort and right click and say - "Hide" or "Distort" and the selected text will become all Xs.

Upvotes: 0

Views: 134

Answers (1)

Matt Donnan
Matt Donnan

Reputation: 4993

As you don't have a definite data structure, I think you would be better to use 'Reversible Encryption' on the string instead, this old question of mine may help you in the right direction.

MS Access VBA Substitution Cipher Encrypt/Decrypt

Upvotes: 1

Related Questions