topic Re: Filter Out Records Containing Russian In Certain Fields in QlikView https://community.qlik.com/t5/QlikView/Filter-Out-Records-Containing-Russian-In-Certain-Fields/m-p/1335455#M823843 <HTML><HEAD></HEAD><BODY><P>This seems to do a reasonable job of identifying the culprits...</P><P></P><TABLE><TBODY><TR><TD>If(Len(KeepChar(Lower(JobTitle),'ёъяшыиющэдфгчйльжзцб'))&gt;0,'Yes')&nbsp;&nbsp; </TD><TD> as [MX User Job Title Russian?],</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 19 Jul 2017 14:52:55 GMT haymarketpaul 2017-07-19T14:52:55Z Filter Out Records Containing Russian In Certain Fields https://community.qlik.com/t5/QlikView/Filter-Out-Records-Containing-Russian-In-Certain-Fields/m-p/1335454#M823842 <HTML><HEAD></HEAD><BODY><P>QV12 SR4</P><P></P><P>One of the data sources into one of our dashboards is pulling in a lot of records that have Russian in certain fields - it appears to be spam related junk and i would like to filter them out if possible.</P><P></P><P>Ideally i would ask them to remove at source but they are unable to help.</P><P></P><P>The Russian appears to be in a number of free text fields such as Job Title.</P><P></P><P>Does anyone have any ideas how best to identify the records ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Filter-Out-Records-Containing-Russian-In-Certain-Fields/m-p/1335454#M823842 haymarketpaul 2020-11-25T16:16:04Z Re: Filter Out Records Containing Russian In Certain Fields https://community.qlik.com/t5/QlikView/Filter-Out-Records-Containing-Russian-In-Certain-Fields/m-p/1335455#M823843 <HTML><HEAD></HEAD><BODY><P>This seems to do a reasonable job of identifying the culprits...</P><P></P><TABLE><TBODY><TR><TD>If(Len(KeepChar(Lower(JobTitle),'ёъяшыиющэдфгчйльжзцб'))&gt;0,'Yes')&nbsp;&nbsp; </TD><TD> as [MX User Job Title Russian?],</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 19 Jul 2017 14:52:55 GMT https://community.qlik.com/t5/QlikView/Filter-Out-Records-Containing-Russian-In-Certain-Fields/m-p/1335455#M823843 haymarketpaul 2017-07-19T14:52:55Z