Selecting columns based on their column name

[nataliad18]

So I have column names such as :

England      USA         27369        Germany    291      London

I ONLY want to select the non-numerical column names (note that field types for all of them are numeric, its the actual column names that differ)

Is there a way to do this? Dynamic select seems to only apply to the actual field name and not to actual column name?

Thanks!
Natalia

[ShankerV · Accepted solution]

Hi @nataliad18 

One way of doing this.

REGEX_Match([Name], "[a-zA-Z ]+")

Input was:

Many thanks

Shanker V

[nataliad18]

Perfect! Thank you!