I have tried using string replacer to remove the blank spaces with commas but it doesn't seem to work? 
I am hoping to get this attribute looking like the below? Any help on how to get here is appreciated.
Best answer by inge
View original
How to replace spaces with commas?
Userlevel 5
+25
- Influencer
- 3345 replies
-
26 March 2021
How do you have your StringReplacer set up? Can you post a screenshot of the parameters?
In the text to replace window I did: (*space*)- will this work?
Userlevel 5
+25
- Influencer
- 3345 replies
-
26 March 2021
In the text to replace window I did: (*space*)- will this work?
No, that will look for the combination ( ), which doesn't occur in your text. Simply putting just a space there should do the trick.
No, that will look for the combination ( ), which doesn't occur in your text. Simply putting just a space there should do the trick.
Great that worked but now i seem to have some with multiple commas? 
is there a transformer that is best to use to now get those values into separate columns?
- Contributor
- 4 replies
-
26 March 2021
- Best Answer
If you use an AttributeSplitter with the comma as a delimiter character, it should work. This Transformer would allow you to drop empty parts. That would eliminate the multiple comma issue.
FYI, he AttributeSplitter has a list as output. Hope this helps!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.