Convert all empty fields to null

[wonka1234]

Hi,

Is there a way to convert all fields from empty to null?

Is the opposite the same as doing a cleanse and replacing null with blank fields?

Thanks.

[gautiergodard]

hey @wonka1234 you could do this:

if IsEmpty([field1]) then Null() else [field1] endif

[wonka1234]

yes this would work but i want it to apply to each col..

ie im trying this but getting malformed funciton call..

[binuacs · Accepted solution]

@wonka1234 You are missing a closing bracket in the isEmpty() function

IF IsEmpty([_currentfield_]) THEN Null() Else [_currentfield_] EndIF