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?