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?
Thanks,
Vann
The regular expression you want is:
^$
For a completely empty cell.
Or:
^\s*$
For a cell that contains only whitespace.
See the second example on this page:
https://www.easydatatransform.com/help/1f/windows/html/replace.html
This is a question that has come up a few time. I will see if I can think of a simpler way.
Thank you. I will use this today.
Vann