SOLVED
Reg ex error
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
Sa743liz-
8 - Asteroid
‎02-27-2023
11:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Labels:
- Labels:
- Error Message
5 REPLIES 5
14 - Magnetar
‎02-27-2023
11:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sa743liz-
RegEx:
^[^\d(]+([\d,.()]+).*$
It will allow decimals, the brackets, and commas within the number
‎02-27-2023
11:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It shows me a parse error
14 - Magnetar
‎02-27-2023
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
14 - Magnetar
‎02-27-2023
12:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Sa743liz- that's actually a little more complex than I originally spotted. You actually have brackets before the numbers sometimes. I think this is actually doing what we want here:
RegEx:
^.*?([\(\d]+[\d,.)]+).*$
It seems to behave as expected in Alteryx:
‎02-27-2023
02:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much that works.
