How to replace an specific character under a column

[patriciousa]

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.

[paul_scotchford · Accepted solution]

Hi

Use this in your script ...

Replace(text, from_str, to_str)

[patriciousa]

Thank you.

Regards.