Standardized telephone format

  • Thread starter Thread starter cinnamngrl
  • Start date Start date
C

cinnamngrl

I am having a lot of trouble removing doubles from my outlook. it is
because identical numbers are formatted differently. My first attempt
to clean it up made things worse. what am i missing? is there a
function that just compares digits, ignoring other characters?
 
No, there's no function like that, you'd have to write one. It wouldn't be
difficult at all, just get the ASC() value of the string character at a
position and compare it to the ASC() values of 0 and 9. If it's between
those it's a number. Anything outside that range (48 to 57) is something
else.
 
Back
Top