how to replace value of specified column to null ？

Question

for example, change the value of Cost Center Code to null

Cost Center CodeTax code706010J4706140J4709384J5709381J4706010J4706002J5

ShankerV · Accepted Answer

Hi @phoebe_90

Please use the formula tool.

IF [Cost Center Code] = "706010"

THEN Null()

ELSE  [Cost Center Code]

ENDIF

Many thanks

Shanker V

dwstada · Accepted Answer

you would select the column in a formula tool and write "null()" as the formula which will overwrite everything in the column