Toad World® Forums

Find and Replacing hex/ascii codes

Using TDP 4.2.1, I am trying to import a worksheet from an excel file. I need to find iascii 160 - "non breaking space" or Hex A0 for every row. Each row is in a string. I want replace it with a space so I can split on every space. Does TDP support search and replace for ascii or hex codes? What tool or automation script should i use?

I'm looking for a way to do it.
In the meanwhile, is there a reason why you don't do the replace in Excel?

The method I was told to use in excel did not seem to work. Can you share how to do it in excel?

Thank you

Can you run replace all in Excel? Just write Alt+0160 to the first field and replace with a normal space.

Will that work for your spreadsheet?