Convert "NULL" text into actual NULL value in multiple fields

[Coral]

Hello, 

Is there a handy tool to convert the "NULL" text values from input source into actual NULL values? 

I would like to convert from this:

Date	Name	Value
NULL	XYZ	NULL
2017-12-01	AAA	4312
2017-12-02	BBB	2412
2017-12-03	NULL	NULL
2017-12-04	AAA	4341
2017-12-05	BBB	5433

into this:

Date	Name	Value
[Null]	XYZ	[Null]
2017-12-01	AAA	4312
2017-12-02	BBB	2412
2017-12-03	[Null]	[Null]
2017-12-04	AAA	4341
2017-12-05	BBB	5433

Thanks, 

Sabrina

[JohnJPS · Accepted solution]

Sure, use MultiField formula with an expression:

IIF(ToString([_CurrentField_])=="NULL",Null(),[_CurrentField_])

[scottj]

Use a Multi-Field formula tool.  Select all the text columns with the formula 

if [_CurrentField_]='NULL' then null() else [_CurrentField_] endif