community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

ReplaceChar with Space

Highlighted

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!

Bolide

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. 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Chirag_Gandhi07

 

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

 

You can still use Replace Function

 

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

 

Cheers,

Thank you!

Labels