Check column for special characters and flag the rows that have them

Question

Hi Guys,

I'm currently having a bit of an issue that you may be able to help me with. I have sample data like so and what I need to do is identify the rows where special characters are present I have tired various approaches and had no luck yet:

NameTest Company 1 LLP â€“ LimitedTest Company 2 â$“ 200 LimitedTest Company 3 â'£ LimitedTest Company 4Test Company 5Test Company 6

The output would look something like this:

NameFlagTest Company 1 LLP â€“ Limited1Test Company 2 â$“ 200 Limited1Test Company 3 â'£ Limited1Test Company 40Test Company 50Test Company 60

Thanks to anyone who can have a look in advance

binu_acs · Accepted Answer

@Deano478 One way of doing this

OllieClarke · Accepted Answer

@Deano478 it depends on what you mean by special characters

@binu_acs's solution will flag anything outside ASCII codes 32-126 (you can see exactly what that equates to here) But if you're just looking to keep letters, numbers and spaces then you can edit the regex to be

RegEx_CountMatches([Field],'[^\l\d ]')>0

With RegEx you need to be very specific in your demands as it is a very precise tool

Ollie