Exclude special characters from DI Studio extract

[EinarRoed]

I have an Extract transformation that needs to extract all rows where EMAIL doesn't include special characters such as "æ", "ø", and "å". How can I accomplish this in the where-statement?

UPDATE: Basically, how can I use EMAIL not contains "æ" but also include "ø" and "å"?

Thanks.

[LinusH · Accepted solution]

Consider to use the indexc function:

http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n04ha26lk1s...