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
Solved! Go to 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+)
Thank you! That worked perfectly!
You may use the almighty text to columns:
Gabriel
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