Pipeline Builder - find and replace date values

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

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!

1 Like

Here is an example:


Thanks Rahul! That does some like the best method available


Map values does exactly what you need.

1 Like