Check first letter of a string

I want to include the rows start with either English alphabet or numbers and remove rows start with non-English alphabet or numerical number. How could I do so? Please help me. Many thanks.

Hi @5lds , this would be best done via Regular Expression. I’m not an expert in Regex, but if I’m attempting to do this, I would say this should work:

^[a-zA-Z0-9].*

Here’s some sample input:
image

Results:
image

6 Likes

That’s fantastic. Thank you a lot.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.