topic Re: Data Checking in QlikView

Data Checking

svsudhakar — Mon, 28 Mar 2016 14:48:30 GMT

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

sinanozdemir — Mon, 28 Mar 2016 15:44:57 GMT

How about the below:

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

Hope this helps.

MarcoWedel — Mon, 28 Mar 2016 23:36:53 GMT

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

regards

Marco