topic Re: Exclude special characters from DI Studio extract in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Exclude-special-characters-from-DI-Studio-extract/m-p/130469#M1755 <HTML><HEAD></HEAD><BODY><P>Consider to use the indexc function:</P><P><A href="http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n04ha26lk1sr1in1043awq6wav80.htm" title="http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n04ha26lk1sr1in1043awq6wav80.htm">http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n04ha26lk1sr1in1043awq6wav80.htm</A></P></BODY></HTML> Tue, 20 Nov 2012 12:27:45 GMT LinusH 2012-11-20T12:27:45Z Exclude special characters from DI Studio extract https://communities.sas.com/t5/SAS-Data-Management/Exclude-special-characters-from-DI-Studio-extract/m-p/130468#M1754 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>UPDATE: Basically, how can I use <STRONG>EMAIL not contains "æ"</STRONG> but also include "ø" and "å"?</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 20 Nov 2012 10:02:27 GMT https://communities.sas.com/t5/SAS-Data-Management/Exclude-special-characters-from-DI-Studio-extract/m-p/130468#M1754 EinarRoed 2012-11-20T10:02:27Z Re: Exclude special characters from DI Studio extract https://communities.sas.com/t5/SAS-Data-Management/Exclude-special-characters-from-DI-Studio-extract/m-p/130469#M1755 <HTML><HEAD></HEAD><BODY><P>Consider to use the indexc function:</P><P><A href="http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n04ha26lk1sr1in1043awq6wav80.htm" title="http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n04ha26lk1sr1in1043awq6wav80.htm">http://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#n04ha26lk1sr1in1043awq6wav80.htm</A></P></BODY></HTML> Tue, 20 Nov 2012 12:27:45 GMT https://communities.sas.com/t5/SAS-Data-Management/Exclude-special-characters-from-DI-Studio-extract/m-p/130469#M1755 LinusH 2012-11-20T12:27:45Z