topic Re: Replace /N with null value in QlikView https://community.qlik.com/t5/QlikView/Replace-N-with-null-value/m-p/1303927#M824848 <HTML><HEAD></HEAD><BODY><P>Thanks it worked</P></BODY></HTML> Thu, 13 Jul 2017 13:36:40 GMT parul_mehta 2017-07-13T13:36:40Z Replace /N with null value https://community.qlik.com/t5/QlikView/Replace-N-with-null-value/m-p/1303924#M824845 <HTML><HEAD></HEAD><BODY><P>I have /N characters in data</P><P>I want to replace /N values with blank</P><P></P><P>Please suggest</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Replace-N-with-null-value/m-p/1303924#M824845 parul_mehta 2020-11-25T16:16:04Z Re: Replace /N with null value https://community.qlik.com/t5/QlikView/Replace-N-with-null-value/m-p/1303925#M824846 <HTML><HEAD></HEAD><BODY><P>Hi Parul,</P><P></P><P>Use Below Code:</P><P></P><P>If(Wildmatch(<STRONG>FiledName</STRONG>,'/N'),null(),<STRONG style="font-size: 13.3333px;">FiledName</STRONG>) as [New Value],</P><P></P><P>Thanks,</P><P>Arvind Patil</P></BODY></HTML> Thu, 13 Jul 2017 13:22:25 GMT https://community.qlik.com/t5/QlikView/Replace-N-with-null-value/m-p/1303925#M824846 arvind_patil 2017-07-13T13:22:25Z Re: Replace /N with null value https://community.qlik.com/t5/QlikView/Replace-N-with-null-value/m-p/1303926#M824847 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">or maybe:<BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">replace(YourField,'/N','') as xxxx</SPAN></P></BODY></HTML> Thu, 13 Jul 2017 13:22:31 GMT https://community.qlik.com/t5/QlikView/Replace-N-with-null-value/m-p/1303926#M824847 m_woolf 2017-07-13T13:22:31Z Re: Replace /N with null value https://community.qlik.com/t5/QlikView/Replace-N-with-null-value/m-p/1303927#M824848 <HTML><HEAD></HEAD><BODY><P>Thanks it worked</P></BODY></HTML> Thu, 13 Jul 2017 13:36:40 GMT https://community.qlik.com/t5/QlikView/Replace-N-with-null-value/m-p/1303927#M824848 parul_mehta 2017-07-13T13:36:40Z