Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
Use this in your script ...
Replace(text, from_str, to_str)
Thank you.
Regards.