How to split the required string from the given string

[Naga]

Hi All,

I have a requirement, where in I need to split the text which has some delimiter of " - " and I need one particular split of the given text.

example - "Alpha - Beta - Gamma - Delta" on this I need only "Beta" in a separate column. I want to us formula then using the text to column option to avoid performance issues considering the volume of data. Please help

Thanks

[danilang · Accepted solution]

Hi @Naga 

Try this in a Regex tool

The Regex string is .*?-(.*?)-.*  which returns every thing between the first and second hyphens

Dan

[Naga]

Thanks Dan, it was very quick. This is solved now.