Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

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
Anil_Babu_Samineni

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

];

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

5 Replies
Anil_Babu_Samineni

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

];

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

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

sunny_talwar

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
Specialist III
Specialist III
Author

Thank you so much @Anil tresesco

vardhancse
Specialist III
Specialist III
Author

Thank you @sunny