Replace a special character in firstname & lastname

[Sekhar]

Hi,

I need query for a replace the special character in firstname & lastname in preprocessor.

Special characters is stored in dataset.

I want to replace the attribute1(Special Character) with  attribute2(Convert Character).

Could you please anyone suggest best solution for this issue.

Thanks,

Sekhar

[rushikeshvartak]

• Add your  list of dataset values under OOTB data set - 

  REPLACE_MAPPING

• Use  in preprocessor - https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter02-Identity-Repository/Datab... 

[Sekhar]

Hi @rushikeshvartak ,

I am getting error if use replace mapping function in preprocessor.

Error: Error in Users Import - Error while processing data: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

Thanks,

Sekhar