Renaming values

[volakakis]

Hi guys!!!!

Little help here needed

I have a Table and one column (B) has values in the format of XXX.##### (for example BSN.70249 )

Is there a way to change the Letter? Lets say BSN.70249 into NIK.70249????

Thank you in advence

[sunny_talwar]

May be this

Replace(B, 'BSN', 'NIK')

[sunny_talwar]

Or this for multiple changes

MapSubstring ‒ QlikView

[volakakis]

No it doesnt work.

BSN.70249 into NIK.70249

BSN.78931 into NIK.78931

and so on

I cant use the proposed ways

[sunny_talwar]

Replace function isn't working? Really?

[volakakis]

not in my load script sorry

[sunny_talwar · Accepted solution]

Seemed to have worked for me

Table:

LOAD *,

  Replace(OriginalValue, 'BSN', 'NIK') as NewValue;

LOAD * Inline [

OriginalValue

BSN.70249

BSN.78931

];

[sunny_talwar]

Check the attached sample

[volakakis]

ok .... my misstake. forgot to rename the new one..... sorry!!!!

Thank you very much