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
|
output:
2 hrs
1 hour
10 mins
12 hours
2 hours
2 hrs
6 Hours
Can this be done using a Parse in CDQ?
Yes you could do this using the CDQ parser with a custom operation using a dictionary or regular expression your choice.
Thanks,
Scott