Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try like this
=KeepChar('abcdaaa abnakenfa 30-Jan. anfeoanfoaewnfoaioenaf','0123456789-')&Left(SubField(' abcdaaa abnakenfa 30-Jan. anfeoanfoaewnfoaioenaf','-',2),3)
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 ?
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