replace String in field

[Anonymous]

Hi All,

I have to update my data at Qlik level where ever we have word 'plant' should be 'Centres'.

Any suggestion. i tried Replace function. it didn't work out.

For example:

Field1

Plant packaging

Covered plant

Output

Centres packaging

Covered Centres.

Thanks

Manish Madan

[Gysbert_Wassenaar · Accepted solution]

Capitalize(Replace(lower(Field1),'plant','Centres'))

[sunny_talwar]

You can try MapSubString function -> MapSubstring ‒ QlikView

Help section provides an example: