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.
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.
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!