DSXchange

I think you're on the right track with Index() and Field(), however not sure you can do all that if logic along with it in one derivation. Can you post the syntax you've tried and the result(s) so far?

What about I would split this derivation into stage variables for efficiency and legibility, though.