Find & Replace on Dot and Star characters

HalMdy

From a Run on a table, we can use the functionality Find & Replace.
But ... when you put . (dot) or * (star) in the field "Find what", the field "replace with" becomes anavailable.

Any trick to avoid that ? We have to replace all dots in "Phone No." (table Contact) with another character ...

Thx and Regards,

Captain_DX4

On first consideration, I would think you'd need to do this in code now. In code, you still cannot search/filter on "." or "*", but you should be able to examine each field though a repetative loop and determine if the characters exist by reading their ASCII values instead.

ajayjain

Try like this

IF Test.find('-') THEN
REPEAT
IF STRPOS(test.desc,'.') > 0 THEN BEGIN
test.desc := CONVERTSTR(test.desc,'.','*');
or
test.desc := DELCHR(test.desc,'=','.');

test.modify;
END
UNTIL test.NEXT = 0;

HalMdy

Tanks for answers gents !!

Question from my customer is : How to do that without coding anything ?

So, I assume answer is : "No way !" . :whistle:

rsfairbanks

Can you not just use a dataport to export, change the data in excel say and then re-import?