Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Convert field value which starts with text or some special characters into 'NLL'

Hi,

Can we make a field value which starts with text or some special characters into 'NLL' .

Field Product#:

950005-11300

950040-11300

91996171-11300

Dongsheng-11300

KINTZ PLAS-11300

N/A-11300

n/a-11300

NA-11300Refer to a-11300

_XNA-11300Refer to a-11300
参考附件-11300

Thanks..


Labels (1)
1 Reply
Claudiu_Anghelescu
Specialist
Specialist

IF(ISNUM(Left(YourFiled,1)), YourField, 'NLL') as YourField
To help community find solutions, please don't forget to mark as correct.