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

[m_woolf]

You can use a Mapping tables.

[sona_sa]

I tried but not got any output.

Regards,

AK

[m_woolf]

Can you share your load script and some sample data?

[sona_sa]

Hi,

I have shared the QVW already.

Again sharing.

Regards,

AK

[m_woolf]

There are no mapping tables in your load script.

[sona_sa]

That I have removed, bcz that not coming properly. Can you fix it. So I can proceed for next.

Regards,

AK

[m_woolf]

After looking again at your script, I think mapping tables won't work.

When you are loading Field, you can do something like:

if([Final Field] = 'V_AREA',

     If(left(Field,2) = 'FT','FT',

          if(left(Field,5)='OPIOT','OPIOT',Field))) as NewField

[sona_sa]

Thanks,

? about T-MOIBLE

Regards,

AK

[vishsaggi]

My be youcan try like below in your script of in an expression.

Subfield(Replace(Field, '-','_'), '_',1)