Filter Out Records Containing Russian In Certain Fields

[haymarketpaul]

QV12 SR4

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.

Ideally i would ask them to remove at source but they are unable to help.

The Russian appears to be in a number of free text fields such as Job Title.

Does anyone have any ideas how best to identify the records ?

[haymarketpaul · Accepted solution]

This seems to do a reasonable job of identifying the culprits...

If(Len(KeepChar(Lower(JobTitle),'ёъяшыиющэдфгчйльжзцб'))>0,'Yes')

as [MX User Job Title Russian?],