Select only string

[BRRLL99]

Hi Team,

I have the following data-set, I would like to extract only string from the data, 

both the columns should be filtered at same time using Formula or regex tool

Input:

Team1	Team2
India (1, 1-0)	Sri Lanka (3,1-0)
Bangladesh (2,1-0)	Bhutan (4,4-0)
Nepal (1,2-0)

Output
Team1	Team2
India	Sri Lanka
Bangladesh	Bhutan
Nepal

[ShankerV · Accepted solution]

Hi @BRRLL99 

Please find the expected output.

Input was:

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[binu_acs · Accepted solution]

@BRRLL99 Another way of doing this with the help of substring and regex functions