Regex: Extract only Alphabetical Characters

Question

Hey Guys!

What would it be the correct expression for a Regex Tool, in order to extract [a-z] characters for this Dataset?

Input

Purchases 11%

Purchases

Purchases 12%

Services 19%

Services

Services 5%

Output

Purchases

Services

I'd appreciate any response from you

Thanks.

atcodedog05 · Accepted Answer

Hi @Cfdiaz2103

Use regex like below. \u stands for upper character and doing a case insensitive find.

Workflow:

Hope this helps : )

drew9 · Accepted Answer

Hi @Cfdiaz2103,

\w+ will match one or more word characters from a field and [[:alpha:]]+ will match one or more letters from a field. both will work in this instance.

You can use the tokenize function of the regex tool to parse out your desired output!

atcodedog05 · Accepted Answer

Hi @Cfdiaz2103

Use regex like below

Workflow:

Hope this helps : )