Replace the column with same value using cleansing script

[opm-btang]

- Import a CSV file with 4,000 rows and 10 columns.
- Inside the data browser, highlight the email column and right click, select the cleansing script that I want to run
- It can convert all email address from lower case to upper case but if I select "revert the column", all email address will be changed to same value.

If I apply the same script to other columns like logon ID, full name ..., I can convert and revert without any problem. However, for email address, this issue happened all the time.

Thanks.

Hi, I tried with your cleansing script and not able to duplicate the issue. For me upper to lower case happens properly and revert column also putting back the orginal values correctly.

For example after applying cleanser script to column an email value "HLiebel@Work.com" is converted to capital "HLIEBEL@WORK.COM" and able to revert the same. This happens for all the records shows in that page. Can you please provide me the steps how you are duplicating the issue?