SOLVED
Regex for Date
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
Pranab_C
8 - Asteroid
‎11-17-2023
10:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Alteryx Champions,
Need help in extracting the numbers that are coming at the end. In the attached screen-shot, I would require -19,911 and 453,590 to come out into a separate column similarly 01/04/22 from the below string:
Date entered..............................................................01/04/22
Solved! Go to Solution.
Labels:
- Labels:
- Regex
5 REPLIES 5
16 - Nebula
‎11-18-2023
12:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try Regex tool or Formula's Regex_Replace function, with "^.*(\d{2}/\d{2}/\d{2}$)".
‎11-18-2023
06:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much for your quick reply, it worked for the dates, can you please help with the second part of the question too.
CoG
14 - Magnetar
‎11-18-2023
07:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Based on the image, something like this may work:
.*\s(.*?\d.*?$)
‎11-18-2023
09:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you that worked out
16 - Nebula
‎11-18-2023
03:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For your reference, Regex Cheat Seat here
