Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Scramble personal id

Hi , i need to scramble personal information, but i can not just randomize the values as i need a unique identifier, could you please advice how i create a unique value which is not random?

Former Member
Former Member replied

Hi Daniel,

this is the formula proposed.

rEPLACE(rEPLACE(Replace(rEPLACE(rEPLACE(Replace(Replace([var];"0";"a");"1";"b");"2";"c");"3";"d");"4";"e");"5";"f");"6";"g");"7";"h");"8";"i");"9";"k")

I can see , by your response that you replacing the "1"s by "3"s.

Avoid substituting a number by another because the formula is evaluated from inside out so, will replace the "3" by "1" first and then the "1" by ";" so you won´t be able to "reconstruct" the actual number.

Regards,

Rogerio

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question