SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Exclude special characters from DI Studio extract

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

Exclude special characters from DI Studio extract

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.


Accepted Solutions
Solution
‎11-20-2012 07:27 AM
Super User
Posts: 5,257

Re: Exclude special characters from DI Studio extract


All Replies
Solution
‎11-20-2012 07:27 AM
Super User
Posts: 5,257

Re: Exclude special characters from DI Studio extract

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation