AnsweredAssumed Answered

Parsing Text String

Question asked by mikethecreative on Oct 6, 2016
Latest reply on Oct 6, 2016 by David Moyer

When importing data, I get the following text string:


{"code":"102","jhrq":null,"rs":"[{\"code\":\"0\",\"content\":\"the server is busy, please try again later\",\"replaceContent\":null}]","orderID":"CARH16100046","message":null}



I want to put the orderID (which in this case is CARH16100046) into a separate field. The orderID is always the same amount of characters and always comes after "orderID":"


I have tried a mixture of calculations using Right, Position, Left, etc and can't seem to get what I want. How can I do this?