Replace /N with null value

[parul_mehta]

I have /N characters in data

I want to replace /N values with blank

Please suggest

[arvind_patil · Accepted solution]

Hi Parul,

Use Below Code:

If(Wildmatch(FiledName,'/N'),null(),FiledName) as [New Value],

Thanks,

Arvind Patil

[m_woolf]

or maybe:

replace(YourField,'/N','') as xxxx

[parul_mehta]

Thanks it worked