SOLVED
Regex Match and trim if a record ends with certain numbers
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
D_Y
8 - Asteroid
‎08-19-2022
12:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I have a list of records that look like this:
Alpha
2 Bravo
18 Charlie 34
Delta12
1 Echo1
Foxtrot8
I am trying to use the Regex_Match function to identify records where the last OR second character is a 1. In this case, Delta12 and 1 Echo1.
Afterwards, I need to remove any character including and after that 1, i.e. return Delta and 1 Echo.
How would I build this out?
Thanks in advance!
Solved! Go to Solution.
Labels:
- Labels:
- Regex
2 REPLIES 2
dYoast
11 - Bolide
‎08-19-2022
01:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-19-2022
01:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!
