Extracting data from the text

[SH_94]

Hi Community,

I would like to ask how do we extract the data below so that it will presnt the output as below. I would like to use the regex formula to do the extraction.

Many thanks

[DataNath]

Hey @SH_94, a couple of questions here. Is there any reason it needs to be regex? Is this a consistent format? My initial thought is that you could just handle it with something simple like so if the format allows:

GetWord([Input], 1)

Regex-wise, there's a bunch of different options but ultimately I'm assuming you're basing the position based on Valuation again, so something like this could work:

Valuation\s([^\s]+)

[ShankerV · Accepted solution]

Hi @SH_94 

One way of doing this with formula as requested is below.

Many thanks

Shanker V

[ShankerV]

Hi @SH_94 

You can use other than formula also like Text to columns and Regex tool.

Many thanks

Shanker V