Below is the string, and the invisible character sits between the space and ‘Co’, which returns ascii value 63 and Unicode value 8206.
‘X Co’
Tried replace(@string, unicode(8206), ''), replace(@string, ascii(63), ''), both failed to work.
Much appreciated if anyone can share the light here.
New contributor
Hu Kai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.