Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vardhancse
Valued Contributor II

Fine & Replace

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.

1 Solution

Accepted Solutions

Re: Fine & Replace

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

];

5 Replies

Re: Fine & Replace

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

];

MVP
MVP

Re: Fine & Replace

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

MVP
MVP

Re: Fine & Replace

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

];

vardhancse
Valued Contributor II

Re: Fine & Replace

Thank you so much @Anil tresesco

vardhancse
Valued Contributor II

Re: Fine & Replace

Thank you @sunny