Lotus 123 script/macro to find and replace

[masseyatgos]

Hi, I'm after a script or macro running from a button that will clean up data. I have customers names which I want to clean up such as find "\0" and replace with "" (nothing). I've tried the script record but cannot get it to work. Please help!

 

[crazybird]

Here is how I remove a series of "bad characters" on the range "DATA":

BadCharSub {ONERROR continue1}
{badChars "#"}
continue1 {ONERROR continue2}
{badChars "&"}
continue2 {ONERROR continue3}
{badChars ";"}
continue3 {ONERROR continue4}
{badChars "-"}
continue4 {ONERROR}


badChr

badChars {DEFINE badChr}
{SELECT data}
{SELECT-RANGE-RELATIVE ;@MAX(1;@ROWS(data)-2);;17;1}
{EDIT-REPLACE-ALL +badChr;;" "}
{BREAK}