How to remove those

[kulasekhar]

Hi All,

Load the following data into qlikview:

LOAD * INLINE [
F1
0570035
0530065
0550099
0560016
0510015
0570010
0520040
0580002
];

Need to filter the data where the values contain the third digit ‘7’ marked in data above.

So output should be :

     F1

---------------
0530065
0550099
0560016
0510015
0520040
0580002

Thanks,

sekhar

[jonathandienst]

In a LOAD:

LOAD ...

WHERE (Substr(F1, 3, 1) <> '7'

Or as an If expression:

     SUM(If(Substr(F1, 3, 1) <> '7', F1))

HTH

Jonathan

[MK_QSL]

LOAD

  *

  Where Index(F1,'7',1) <> 3;

LOAD TEXT(F1) as F1 INLINE

[

  F1

  0570035

  0530065

  0550099

  0560016

  0510015

  0570010

  0520040

  0580002

];

[kulasekhar]

Thanks

Manish

[awhitfield]

HI Kula,

try this please:

160553:
Load * Inline
[
F1
0570035
0530065
0550099
0560016
0510015
0570010
0520040
0580002
];

Results:
NoConcatenate Load
F1

Resident 160553
Where
Mid(F1,3,1)<>'7'
;

Drop table 160553;

Regards

Andy

[nagarjuna_kotha]

Hi ,

Kind find below attached file .let me know its working to u or not ?

Regards,

Nagarjuna

[kulasekhar]

F1

  1234567

  1234576

  1234756

  1237456

  1273456

  1723456

  7123456

How to remove All "7"

[awhitfield]

160553:
Load * Inline
[
F1

1234567
1234576
1234756
1237456
1273456
1723456
7123456
];

Result:
NoConcatenate LOAD

PurgeChar(F1,7) as F1

Resident 160553;

[kulasekhar]

doesn't work

first row 7 only remove

[kulasekhar]

thanks but i don't have trial variation