Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
svsudhakar
Creator
Creator

Data Checking

Hi All,

Is it possible to check the below condition in Qlikview Script level.

Ex: I have an data like Below

 

AU WACUA TP
SQ-793578/3791862/3760163/3760248/3685781/3614436/reb/T1/EG/DATA#3
SQ-
Vol-Dir\Hp BLc VC\DEPT OF Defence
SQ- 3795145/3750960/3725862/ SQ-3644201/3566197

Now i want to check if my field value starts with SQ-[0-9] ([0-9] is the number range) then condition True else False

Please help on this

2 Replies
sinanozdemir
Specialist III
Specialist III

How about the below:

Capture.PNG

This assumes that there is no additional space between 'SQ-' and the starting number.

Hope this helps.

MarcoWedel

‌If(field like 'SQ-*' and IsNum(Mid(field,4,1)), true, false)

regards

Marco