Extract value from single cell

[k3pineapple]

Hi All,

Seeking your kind help to extract value from cell.

I am trying to use "Text To Columns" by using "} {" at the first step, seems not working.

Not sure what should i start now. Thx for the help.

Input

Rank	Platform 2
1	{Apple.ABCDEF} {Banana.ABCDEF}
2	{Apple.GH IJ KL} {Banana.GH IJ KL} {Cherry.GH IJ KL}
3	{Banana.ZXC VBN} {Apple.ZXC VBN}

Output

Rank	Platform 2
1	ABCDEF
2	GH IJ KL
3	ZXC VBN

[Yoshiro_Fujimori · Accepted solution]

Hi, @k3pineapple ,

I would use RegEx tool and RegEx function for this kind of pattern matching.

Workflow

RegEx tool configuration

Formula tool expression

For the usage of RegEx, this site would be useful.

https://regex101.com/

Good Luck!

[binu_acs · Accepted solution]

@k3pineapple One way of doing this

.*\.(.*)}

[anandakrishnan]

@binu_acs Yes. Its the best and smart way to solve it