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

[kkkim]

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!!!

[binuacs]

@kkkim use the below formula

REGEX_Replace([Field1], "[^ -~]", '$1')

[kkkim]

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!

[DataNath]

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

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

Before vs after using this:

[binuacs]

@kkkim updated the formula

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