In Trifacta or Google Cloud Dataprep, i'm trying to flag rows with non alpha numeric (�). What formula do I use? tried this formula but doesn't work

Replace Matches of `�` from EMPLOYEE_FIRST with NOT VALID
1

There are 1 best solutions below

6
On BEST ANSWER

Can you clarify what you mean by "doesn't work"?

The following step works for me in Dataprep. You can paste it directly into the New Step wizard:

replacepatterns col: EMPLOYEE_FIRST with: 'NOT VALID' on: `�` global: true

If that does not work for you, can you please post a screenshot of what happens after adding (or trying to add) this step?