Filter if contains alphabets
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BautistaC888
8 - Asteroid
‎08-18-2022
12:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I need to filter every record in the field that contains Alphabets in any part.
I attached an example.
Thank you.
Labels:
- Labels:
- Preparation
- Regex
3 REPLIES 3
DavidSkaife
14 - Magnetar
‎08-18-2022
01:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is one way of doing it, using the code
REGEX_CountMatches([text], "[[:alpha:]]" ) =0
:
It counts the number of times a letter appears and filters out records where the count is 0
Emmanuel_G
13 - Pulsar
‎08-21-2022
05:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
21 - Polaris
‎08-21-2022
06:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BautistaC888
I hope this works.
