Showing results for 
Search instead for 
Did you mean: 

Looking for a formula to replace specific words in a field?

Validity Team Member
Validity Team Member

Use the DTV modify module and choose the formula tab. 

Enter this formula:

RegExReplace( {field to update here} , "0|Not Provided|not provided|null|(N\/A)|\(not provided\)|\?" , "") 

In this instance, the words to be replaced are 0, Not Provided, not provided, null, N/A, ?, and (not provided). The last set of empty quotations indicate to replace the specified words with a null value; however, if you want to replace with another word, enter the word in the last set of quotations. 

Note: If wanting to replace mutliple values with a specific word, each value must be separated by a pipe - | as per the above example.