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.
Page 1 / 1
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?
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?
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 E-mail address. We'll send you an e-mail with instructions to reset your password.