How do I filter out a column's item that start with alphabet letter?
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
ryanzhang487
8 - Asteroid
‎10-20-2023
11:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
3 REPLIES 3
SPetrie
13 - Pulsar
‎10-20-2023
11:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A filter tool using REGEX_Match([Order Number],"\d.*")
rzdodson
12 - Quasar
‎10-20-2023
11:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Assuming the records you want always have a four digit prefix, followed by a hyphen, then followed by three digits, you can use Regex_Match in a filter tool to get the records you want.
17 - Castor
‎10-23-2023
03:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ryanzhang487
You can also try this:
REGEX_Match([Order number], "^[A-Za-z].*")
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
