Select only string

Question

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:

Team1Team2India (1, 1-0)Sri Lanka (3,1-0)Bangladesh (2,1-0)Bhutan (4,4-0)Nepal (1,2-0)

Output Team1Team2IndiaSri LankaBangladeshBhutanNepal

ShankerV · Accepted Answer

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 Answer

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