How do i replace text in a field as Null

[Anonymous]

Hi,

How do i replace text in a field as Null

Name

John

N/A

N/A

Paul

I want to change the 'N/A's in Name field to NULLS.

Thanks

[marcus_sommer · Accepted solution]

Try: if(Name = 'N/A', null(), Name) as Name

- Marcus

[avinashelite]

//in front end

If(Name='N/A','',Name)

//in backend

If(Name='N/A','',Name) as Name

[Anonymous]

Thanks

ARHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH!

I was missing the '()' on null()

Thanks.