topic Fine & Replace in QlikView

Fine & Replace

vardhancse — Tue, 09 May 2017 10:58:21 GMT

Hi Team,

Here is the table loaded.

Sample:

LOAD * INLINE [

S.No, Region

1, USA.Atlanta

2, USA.California

3, USA.California.Bayarea

4, India.Karnataka.Tamilnadu.Chennai

];

Now the requirement is to replace . with space(" ")

Region

USA Atlanta

USA California

USA California Bayarea

India Karnataka Tamilnadu chennai

Can please one please let me know any function to use.

Re: Fine & Replace

Anil_Babu_Samineni — Tue, 09 May 2017 11:00:34 GMT

May be this?

Sample:

LOAD [S.No], Replace(Region,'.',' ') as Region INLINE [

S.No, Region

1, USA.Atlanta

2, USA.California

3, USA.California.Bayarea

4, India.Karnataka.Tamilnadu.Chennai

];

Re: Fine & Replace

tresB — Tue, 09 May 2017 11:01:16 GMT

Replace(Region, '.',' ') as NewRegion

Re: Fine & Replace

sunny_talwar — Tue, 09 May 2017 11:03:29 GMT

Another option

Mapping:

Mapping

LOAD * Inline [

Find, Replace

., " "

];

Sample:

LOAD S.No,

MapSubString('Mapping', Region) as Region;

LOAD * INLINE [

S.No, Region

1, USA.Atlanta

2, USA.California

3, USA.California.Bayarea

4, India.Karnataka.Tamilnadu.Chennai

];

Re: Fine & Replace

vardhancse — Tue, 09 May 2017 11:04:11 GMT

Thank you so much @Anil tresesco‌

Re: Fine & Replace

vardhancse — Tue, 09 May 2017 11:04:53 GMT

Thank you @sunny