https://mycommunity.validity.com/t5/demandtools/looking-for-a-formula-to-replace-specific-words-in-a-field/m-p/950#M504 <P>Use the DTV modify module and choose the formula tab.&nbsp;</P> <P>Enter this formula:</P> <P><SPAN>RegExReplace( {field to update here} , "0|Not Provided|not provided|null|(N\/A)|\(not provided\)|\?" , "")</SPAN>&nbsp;</P> <P>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.&nbsp;</P> <P>Note: If wanting to replace mutliple values with a specific word, each value must be separated by a pipe - | as per the above example.&nbsp;</P> <P>&nbsp;</P> Thu, 15 Jun 2023 13:51:22 GMT ajavalidity 2023-06-15T13:51:22Z https://mycommunity.validity.com/t5/demandtools/looking-for-a-formula-to-replace-specific-words-in-a-field/m-p/950#M504 <P>Use the DTV modify module and choose the formula tab.&nbsp;</P> <P>Enter this formula:</P> <P><SPAN>RegExReplace( {field to update here} , "0|Not Provided|not provided|null|(N\/A)|\(not provided\)|\?" , "")</SPAN>&nbsp;</P> <P>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.&nbsp;</P> <P>Note: If wanting to replace mutliple values with a specific word, each value must be separated by a pipe - | as per the above example.&nbsp;</P> <P>&nbsp;</P> Thu, 15 Jun 2023 13:51:22 GMT https://mycommunity.validity.com/t5/demandtools/looking-for-a-formula-to-replace-specific-words-in-a-field/m-p/950#M504 ajavalidity 2023-06-15T13:51:22Z