Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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