This is what my output looks like the below when using the summary tool and concatenate. I want to remove any leading or trailing commas. How can I do that?
Column 1 Column 2 Column 3
2691612,,,, ,,,,DN ,10101,50101,50102,
The regex tool is going to be your best bet since you can use wildcards to say 0 or more of the comma on either side of the data. Take a look at www.regex101.com or www.regexone.com if you aren't familiar with regex.
Hi,
You can use Data cleansing tool and select the columns you want to cleanse and click on Punctuation like in the below screenshot. Please Mark as solution if it was helpful
@cowannbell here is another approach using a Multi-Field Formula tool.
I would actually go using Multi field formula tool, because imagine if you have decimals somewhere, punctuation with data cleanse would be making it worse
Thanks but this removes all commas
This removes all commas. I want to keep the commas between numbers/text.
@cowannbell slightly different approach based on your previous post.
I found the correct expression. (^[,\s]+)|([,\s]+$)
