Replace #N/A with blank

Question

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 Answer

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

AncientPandaman · Accepted Answer

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.