Regex: Extract only Alphabetical Characters

[Cfdiaz2103]

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

Purchases

Purchases

Services

Services

Services

I'd appreciate any response from you

Thanks.

[atcodedog05 · Accepted solution]

Hi @Cfdiaz2103 

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

Workflow:

Hope this helps : )

[drew9 · Accepted solution]

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!

[Cfdiaz2103]

Hey @atcodedog05 !

It works perfectly. However, if I had a value like this: Withholding Tax 11%, What expression should I use to obtain the value: Withholding Tax?

I'd appreciate your support.

[atcodedog05 · Accepted solution]

Hi @Cfdiaz2103 

Use regex like below

Workflow:

Hope this helps : )