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: 
boopeshj
Partner - Creator II
Partner - Creator II

Find presence of a number combination in a string

Hey Expert

I would like to find if a string contains 09-12 or 09-Dec. Any suggestions. 

" abcdaaa abnakenfa 30-Jan. anfeoanfoaewnfoaioenaf "

Regards,

Boopesh

 

Labels (1)
3 Replies
avinashelite

try like this 

=KeepChar('abcdaaa abnakenfa 30-Jan. anfeoanfoaewnfoaioenaf','0123456789-')&Left(SubField(' abcdaaa abnakenfa 30-Jan. anfeoanfoaewnfoaioenaf','-',2),3)

boopeshj
Partner - Creator II
Partner - Creator II
Author

Thanks @avinashelite  but I would like to check if this kind of String exists. 

I was thinking more in lines of search if there is something like 99-abc , I believe we could achieve this by a regular expression. Any idea on that lines ?

 

avinashelite

We don't have regular expression kind in Qlik for string matching ......

Probably this article would be close enough 

https://community.qlik.com/t5/QlikView-Scripting/Regular-expression-A-Z/td-p/851408