topic Re: Convert field value which starts with text or some special characters into 'NLL' in QlikView https://community.qlik.com/t5/QlikView/Convert-field-value-which-starts-with-text-or-some-special/m-p/1552418#M744083 IF(ISNUM(Left(YourFiled,1)), YourField, 'NLL') as YourField Tue, 05 Mar 2019 14:07:53 GMT Claudiu_Anghelescu 2019-03-05T14:07:53Z Convert field value which starts with text or some special characters into 'NLL' https://community.qlik.com/t5/QlikView/Convert-field-value-which-starts-with-text-or-some-special/m-p/1552298#M744082 <P>Hi,</P><P>Can we make a field value which starts with text or some special characters into 'NLL' .</P><P>Field Product#:</P><P>950005-11300</P><P>950040-11300</P><P>91996171-11300</P><P>Dongsheng-11300</P><P>KINTZ PLAS-11300</P><P>N/A-11300</P><P>n/a-11300</P><P>NA-11300Refer to a-11300</P><P>_XNA-11300Refer to a-11300<BR />ๅ‚่€ƒ้™„ไปถ-11300</P><P>Thanks..<BR /><BR /><BR /></P> Sat, 16 Nov 2024 21:18:29 GMT https://community.qlik.com/t5/QlikView/Convert-field-value-which-starts-with-text-or-some-special/m-p/1552298#M744082 nareshthavidishetty 2024-11-16T21:18:29Z Re: Convert field value which starts with text or some special characters into 'NLL' https://community.qlik.com/t5/QlikView/Convert-field-value-which-starts-with-text-or-some-special/m-p/1552418#M744083 IF(ISNUM(Left(YourFiled,1)), YourField, 'NLL') as YourField Tue, 05 Mar 2019 14:07:53 GMT https://community.qlik.com/t5/QlikView/Convert-field-value-which-starts-with-text-or-some-special/m-p/1552418#M744083 Claudiu_Anghelescu 2019-03-05T14:07:53Z