extracting date from a string
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Alteryx Community,
I have columns as shown below.
loan activites 12/11/2021 12.00.00 |
loan activites_NA 12/11/2021 11.33.99 |
I have to extract date from the string. Can anyone help
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @vamsey ,
You might also try using regex:
DateTimeParse(
REGEX_Replace([Field1], '.*\s(\d+/\d+/\d+).*', '$1'), '%d/%m/%y')
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @vamsey ,
in addition to what @PhilipMannering said, you could regex to parse out the mask:
Workflow attached.
I hope this helps,
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
below columns are not able to output the dates using the formulae. Can you please help
Report free of Soan BQ Outstanding Activities_11-08-2021 17-30-45.0000000.xlsx
Report free of Soan BQ Outstanding Activities_11-09-2021 17-30-36.0000000.xlsx
Report free of Soan BQ Outstanding Activities_11-10-2021 17-30-41.0000000.xlsx
Report free of Soan BQOutstanding Activities_NA 11-08-2021 17-30-45.0000000.xlsx
Report view of Loan IQdfd Outstanding Activities_NA 11-09-2021 17-30-36.0000000.xlsx
Report view of Loan IQed Outstanding Activities_NA 11-10-2021 17-30-41.0000000.xlsx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @vamsey ,
change the regex in my Regex tool to the following:
(\d\d[/]\d\d[/]\d{4}|\d\d[-]\d\d[-]\d{4})
You'll need to change the name back to Date or whatever.
M.