Alteryx - Date Parsing/Cleanup using REGEX
ฝัง
- เผยแพร่เมื่อ 23 ก.ค. 2024
- In this video, I show you how to parse through data using the data analytics tool Alteryx and the Regex function.
Key Tools Used: Regex
A dataset contains a text field that has a date embedded within the text. The problem is that the date is represented a few different ways. For example:
-16-APR-2005
-Nov•16,•1900
-4-SEP-00
-Jan•5•2000
The goal is to create a new Date/Time field populated with the dates contained within the text field. You will also need to standardize the dates so that they are all formatted the same.
Link: community.alteryx.com/t5/Week... - กีฬา
Hi Willy, I have date in format “yyyymm” and I want to convert to date “yyyy-mm-dd” when I use custom format it gives the wrong month. Ex- “199704” to “1997-01-01” instead of April it’s giving January. Could you help with this? Thanks a lot!