Regex_Match - Keep only rows containing alphabets and/or numeric values

Question

Hi, Experts!

I have some rows containing special characters and non ASCII letters that need to be removed. Only rows containing alphabets and numeric values should be retained.

Any thoughts on how to run regex_match on this?

Thank you so much for your help!!!

binu_acs · Answer

@kkkim updated the formula

REGEX_Match([Field1], "[^ -~]")

DataNath · Answer

Hey @kkkim, you can use the following in a Filter expression:

REGEX_Match([Input], '[a-z0-9]+')

Before vs after using this:

kkkim · Answer

Thanks for your feedback. Unfortunately, this is not yielding the result I need. I am trying to use regex_match formula to keep only rows that contain alphabets and/or numeric values. Thanks again!