How to perform string operation on JSON MEL in mule esb

Question

I want to perform some string operation on MEL I have following expression in MEL

<logger message="#[json:xy/PID/xy.3/AC]" level="INFO" doc:name="Logger"/>

OUTPUT IS

19901026000000

I want to extract 1st 4 digit then 6,7 digit .

How can I do this ??

Thanks

Answer 1

What about trying it in two steps?

<set-variable variableName="result" value="#[json:ADT_A01/PID/PID.3/CX.1]" />
<set-variable variableName="result" value="#[result.substring(0,4)]#[result.substring(5,7)]" />