Regex: Extract only Alphabetical Characters
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Cfdiaz2103
Use regex like below. \u stands for upper character and doing a case insensitive find.
Workflow:
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
