Get Right of Second - (dash)

[ptmuldoon]

I am pulling in data from a JSON source, and one the fields that is imported looks something like such:

Number - Location - Description

And I need to put into a new column, just that Description part.  ie, what is to the right of the second dash in the string.

Any thoughts on the formula for that?

Thank you,

PT

[ImkeF · Accepted solution]

Hi @ptmuldoon ,
yes, check that column and then add a new column like so:

 then:

I would choose the option "From the end of the input",
but you can also start from the beginning and then skip as many delimiters as you need.