google-cloud-platformgoogle-cloud-datapreptrifacta

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

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
Solution

  • 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?