Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

patriciousa
Contributor

How to replace an specific character under a column

Hi guys.

I have a question on what must be an easy task... I have to replace an specific character under a column.

This is what I'm loading in Sense.

Name
John,Green
Mike,Red
Stephanie,Roberts
Patrick Isaac,Ortner

I have to replace the "," by " " (one space)

How do I do it? Where do I put in the load script?

Thank you in advance.

Regards.

1 Solution

Accepted Solutions
paul_scotchford
Valued Contributor

Re: How to replace an specific character under a column

Hi

Use this in your script ...

Replace(text, from_str, to_str)



2 Replies
paul_scotchford
Valued Contributor

Re: How to replace an specific character under a column

Hi

Use this in your script ...

Replace(text, from_str, to_str)



patriciousa
Contributor

Re: How to replace an specific character under a column

Thank you.

Regards.