What’s the best way to perform a find and replace on a date column using Pipeline Builder?
- Replacing all instances of a date value with null
- Replacing one specific date value with another
What’s the best way to perform a find and replace on a date column using Pipeline Builder?
Hi Daniel,
An easy way that you can accomplish this is to use the Cast board to convert the date to a string.
To replace a date with another Date: you can then Regex replace the date string with the new date. And then you can Cast this string back to a Date.
To replace with null: You can Regex replace the date with an empty string, nullify empty strings for that column, and then cast back to a date.
Note that there may be other methods to do this, but this was the best that I could find!
Thanks Rahul! That does some like the best method available