Extract value from single cell

Question

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 21{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 21ABCDEF2GH IJ KL3ZXC VBN

Yoshiro_Fujimori · Accepted Answer

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 Answer

@k3pineapple One way of doing this

.*\.(.*)}