Data Parsing

[chulett]

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?

[ArndW]

What about

Code: Select all

 IF FIELD(In.BigColumn,"MOO",2)[18,3]="PR " THEN FIELD(In.BigColumn,"MOO",2)[21,50] ELSE ""

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