ReplaceChar with Space

[Chirag_Gandhi07]

Hi everyone,

I have the following data:

Name

James;Smith

I used a formula tool and did: ReplaceChar([Name], ";", ", ")

What I got was: James,Smith

I would like James, Smith

Am I doing something wrong with the ReplaceChar formula? Any help would be greatly appreciated. Thanks!

[JoBen · Accepted solution]

Hi @Chirag_Gandhi07, why don't you try this formula instead. REGEX_Replace([Name] "\;", ", "). I believe the ReplaceChar formula is replacing one character with only one character. Since you are trying to replace one character (";") with two (a comma and space), it is uisng the first replacement character to replace the semi-colon. 

[Thableaus · Accepted solution]

Hi @Chirag_Gandhi07

ReplaceChar replaces exactly one char. It's not recommended in your case.

You can still use Replace Function

Replace([Field],";",", ")

Cheers,

[Chirag_Gandhi07]

Thank you!