topic Re: replace String in field in QlikView

replace String in field

Anonymous — Tue, 24 May 2016 14:53:46 GMT

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 — Tue, 24 May 2016 14:58:28 GMT

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

sunny_talwar — Tue, 24 May 2016 14:58:50 GMT

You can try MapSubString function -> MapSubstring ‒ QlikView

Help section provides an example: