Imported Data: Replace Non printable character with a space

  • Thread starter Thread starter ksp
  • Start date Start date
K

ksp

I have some alphanumeric data imported from a Database. If the user hit
the "enter" key when they type the text into this DB, I end up with
'square' ie looks like CHAR(10) within the text.

If I use the Clean function it gets rid of it but I need to replace i
with a space. I have also tried doing a replace, but can't "Find" th
character

Does anyone have any suggestions?

Thanks

Kare
 
Back
Top