1 Reply Latest reply on Feb 17, 2021 3:20 AM by user126898

    Cloud Data Quality -Parser

    Ajay Perumal New Member
    Ajay Perumal Feb 16, 2021 9:23 PM

      Hi All,

       

      I want to parse a column which contains hours(hrs,hours),mins(minutes,mins) in Parse asset in cloud Data quality and return the value.

       

      Sample input:

       

      1 - 2 hrs (Faster on absorbent surfaces)
      1 hour
      1 hour dependent upon temperature and humidity
      10 mins
      12 hours

      1-2 hours

      1-2 hrs

      Touch dry 2-6 Hours

       

      output:

      2 hrs

      1 hour

      10 mins

      12 hours

      2 hours

      2 hrs

      6 Hours

       

      Can this be done using a Parse in CDQ?