Search and Replace with <null>

Jeremy Myers

Anyone know what the null value is in Smartsheet when using the search and replace function?  I tried, "", <> and all the usual tricks- no go.

 

I want to search for a particular word in a string and replace it with.....nothing.

Travis

Jeremy - leaving the "Replace with" field blank and selecting Replace All will replace your string with "nothing".

Jeremy Myers

Right you are.  Never considered that angle....

 

Thnx for the support.

chad.leman83441

I have the same issue, and I don't understand Travis's solution. Can you please clarify how this finds a null value in a field and replaces it with something else?