I'm looking to extract certain text from a text string. In the sample data below, I'd like to extract the two character country code that comes after the first underscore. The number of characters before that first underscore will be different.
Is there a RegEx expression that can help with this? Or a different solution? Thanks!
sample data
The Dillinger Escape Plan - Miss Machine - Relapse_US_Label_2004
The Dillinger Escape Plan - Dissociation - Party Smasher_US_Label_2016
Solved! Go to Solution.
Hi
The easiest way i think is to use the text to coloumns tool setting the delimeter to underscore.
Quick, easy, regex free :-)
This is perfect. Thank you!