remove unused character from field and value

[sona_sa]

Hi,

From DTC TEST CONFIG NAME string, now I have separated Operator, RAT and V_AREA on behalf of TestEnvironmentSIM1, TestEnvironmentSIM1 --> Operator, RAT1, RAT2 --> RAT

Now I want to replace for Operator to T-MOBILE D and T-MOBILE US to T-MOBILE by script level.

and

For V_AREA --> I want remove after - and _, Only I want FT and OPIOT, Thats it.

Please find the attached qvw for ref.

Thanks & Regards,

AK

[vishsaggi]

May be try this?

Mid([DTC TEST CONFIG NAME], Index([DTC TEST CONFIG NAME],'T-MOBILE'), 😎