Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
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.
Comments
-
Jeremy - leaving the "Replace with" field blank and selecting Replace All will replace your string with "nothing".
-
Right you are. Never considered that angle....
Thnx for the support.
-
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?
This discussion has been closed.