ReGex match for non standard alphabet

[aatalai]

Hi I'm looking to at this data redacted for data reasons to just the first letter

Field 1
É
É
É
À
À
Ø
Å
Å
Ü
Ü
É
é

Want to know how can I construct a regex or other way to detect the first letter of what it is I tried \W in regex match and was unsuccessful

[myastarling · Accepted solution]

There is a similar post which addresses the extended latin unicode range -- I hope this is helpful:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-separate-Latin-and-non-...

REGEX_MATCH([FirstName],"^[A-Z \x{80}-\x{24F}-]+$")

[Pilsner]

Hello @aatalai 

I'm not certain I have understood your request properly, but I have a couple of ideas on how to replicate your output.

If you are just wanting to take the first character, you can use a "." in REGEX.

If you are trying to mask data, you may also want to replace the other characters with *. Here's how I approached this.

 

I have attached the workflow below.

Please let me know if you have any questions.

Regards - Pilsner

[binuacs · Accepted solution]

@aatalai another way of extracting the first non-ascii letter using regex

!REGEX_Match([Field1], '[^ -~]')