Hi Claire - are you getting the data from Surface Automation, where visually some characters in some fonts are identical. Lower L and upper i are often identical in appearance. The code you have looks like something to clean up such data, but you have to think before using it, because the result may be just as wrong. For example, if you know the fiel can only contain letters, the when Surface Automation reads C1aire it must really be Claire. Or, you may decide that a capital letter cannot exist in the middle of a word, so CIaire (upper i instead of lower L) must be Claire. You have to be sure the logic is correct before attempting to fix, and if the logic is not sound, then applying a fix is a risky guess.
------------------------------
John Carter
Professional Services
Blue Prism
------------------------------