Simple Reg ex help

renee12345

I have rows that look like this:

Interview with Bob Dylan - CSM

and want to parse just the CSM. I tried using Replace Text file, selecting reg ex and using this:

-.*

but it returned the former portion. Any recommendations on what reg ex to use?

MarkSnodgrass

You can use the formula tile and the split_part function to get the string after the hyphen. Your formula would look like this:

TRIM(SPLIT_PART(fieldname,'-',2))

This will get the value after the dash and remove any extra spaces.

MarkSnodgrass

You can use the formula tile and the split_part function to get the string after the hyphen. Your formula would look like this:

TRIM(SPLIT_PART(fieldname,'-',2))

This will get the value after the dash and remove any extra spaces.

renee12345

awesome thank you @MarkSnodgrass

marcel_luthi

Keep in mind that if your string contains more than a single -, you might need to update the formula slightly. @MarkSnodgrass video on how to build a word can be used as a reference to build this, you only need the part to know how many - are in the original string to know to get the last part.