Replace #N/A with blank

[PassION_es]

Hi,

Any alternative to remove N/A from all fields? I used transpose, find replace tool and cross tab tool.  Just thinking if there's any alternative solution.

Thank you.

[OTrieger · Accepted solution]

@PassION_es 
You can use Multi Fields Formula to do the same to multiple fields at the same time

[PangHC · Accepted solution]

you can use multiple field tool

if [_CurrentField_]="N/A" then 
  null()
else
  [_CurrentField_]
endif

then check all the target fields in the field sections
note: not check the copy output.

[PassION_es]

thank you @PangHC & @OTrieger