I have a large list of emails and some of them begin with a CR or tab. Is it possible to search for ASCII characters like these?
Char(10) – New Line / Line Break
Char(13) – Carriage Return
Char(9) – Tab
Thanks for your help!
Zhava
I have a large list of emails and some of them begin with a CR or tab. Is it possible to search for ASCII characters like these?
Char(10) – New Line / Line Break
Char(13) – Carriage Return
Char(9) – Tab
Thanks for your help!
Zhava
Yes. You just use the functions.
select Email beginswith chr(10) or Email beginswith chr(13) or Email beginswith chr(9)
You could also use the lf(), cr(), and tab() functions respectively.
If you simply want to remove any of these white space characters you can use the strip(
function to automatically strip them off.
Strip( removes leading or trailing white space, but leaves it within the body. OneWhiteSpace( removes ‘extra’ white space characters throughout.