I have a requirement where a customer will export their case data however, they also want to remove/mask any PII data from the case export.
All that I have read on this topic is platform encryption or data masking for sandbox etc. This will not work for a data export if I understand.
Can anyone suggest a way to achieve this? Can this be done in a data export or data loader perhaps?
I am also thinking if not possible in the export then is there a way to run some job on a csv file that will achieve this? Any excel tools/tips here?
Thanks in advance.