How to deal with unicode / special / invisible characters?

Thanks @ScottF. Nice article :slight_smile:

This topic came up on another post recently, with the problem of identifying “spaces”. It mentions some additional components that can assist:

In particular, it seems that Excel likes to add “non breaking spaces”, and these can be “fixed” instead of “stripped” using Unicode Space Replace:

1 Like