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...
  • กีฬา

ความคิดเห็น • 1

  • @facethetruth00
    @facethetruth00 3 ปีที่แล้ว

    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!