replacing characters

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

I need to REPLACE all characters in a text field that do not match the basic
26 character set. That includes, parenthesis, commas, spaces, quotes, etc.
Is there any quick way to do this without laying out each bad character in a
REPLACE formula?

thanks!
 
Use the Mid function in a loop to look at each character in the text field.
Within the loop use the Asc function to compare the ascii value of the
character with acceptable ascii values (expressed as a range of ascii
values) and replace the character if its ascii value is not acceptable.
 
Back
Top