Get Right of Second - (dash)

Question

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 Answer

Hi&nbsp;ptmuldoon&nbsp;,yes, check that column and then add a new column like so:

&nbsp;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.

Forum Discussion