Regex replace? Need to extract a text after certain character... Help!!!

[kkkim]

Hi, All:

I need to extract a text immediate following " - ". Any suggestions on how to implement this? Attaching an example of original text and outcome text.

Thank you for your help!!!!

Original:

JohnSmith - Blue Is Cool

Outcome:

Blue

[DataNath · Accepted solution]

If your string will always follow this kind of format then you can use the RegEx tool in parse mode with the following expression:

-\s(\w+)

If the space won’t always be there after the - then use:

-\s?(\w+)

[kkkim]

Thank you! That worked perfectly!

[Garabujo7]

You may use the almighty text to columns:

Gabriel

[Garabujo7]

And if would like to try regex:

-(.+)

That will bring you everything after the -

There's also a nice cheat sheet that you could use in the regex tool as well.

Gabriel