Can I search for ASCII characters?

Panorama X
#1

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

#2

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.

#3

If you simply want to remove any of these white space characters you can use the strip( function to automatically strip them off.

#4

Strip( removes leading or trailing white space, but leaves it within the body. OneWhiteSpace( removes ‘extra’ white space characters throughout.