Replace blank cell?

How can the replace transform be used to fill all the blank records in a column with a value? I have be using the IF transform but that seems to be the long way around. I checked using regexl but failed to get anything to work?

The regular expression you want is:


For a completely empty cell.



For a cell that contains only whitespace.

See the second example on this page:

This is a question that has come up a few time. I will see if I can think of a simpler way.

This is going to be an option in v1.15.1:

1 Like

Thank you. I will use this today.