3 Replies Latest reply on Aug 30, 2018 9:32 AM by meenu choudhary

    REGEXP_EXTRACT from a given String that stays constant - Extract Date

    Ankit Patel

      So I am new to RegEx or REGEXP. If you are familiar with it - my use case is to extract Date from a long String and convert the extracted string to a Date.

       

      Values in FileName:

      StateFileReportDataFileFTP_40030_2018-01-12_R104000492z.xlsx

      StateFileReportDataFileFTP_40030_2018-08-24_R104000580z.xlsx

      StateFileReportDataFileFTP_40030_2018-08-17_R104000782z.xlsx

      StateFileReportDataFileFTP_40030_2018-08-10_R104000810z.xlsx

       

      Desired Output Date:

      2018-01-12

      2018-08-24

      2018-08-17

      2018-08-10

       

      Thanks for your help in advance. Attached is sample workbook.