topic Re: Remove leading / trailing commas in App Development

Remove leading / trailing commas

ccifaldi — Wed, 08 Jun 2022 20:14:27 GMT

Hello! I have text data that is combined from multiple fields. The values need commas between them, which I have added. However, some of the fields are blank and the result yields multiple commas in a row. I am using Replace to remove multiple commas in a row. However, I need to remove any leading or trailing commas as well. First image below is script to combine the fields. Second image is the replace function. Third is the output before and after the replace function.

Re: Remove leading / trailing commas

vinieme12 — Thu, 09 Jun 2022 06:19:33 GMT

Try As below

=Mid(Replace(field,',,',''),2)

Re: Remove leading / trailing commas

ccifaldi — Thu, 09 Jun 2022 12:44:09 GMT

Thanks! However, this does not work. It drops the leading comma and the first character of the next field because of the 2. It also leaves in tact all the multiple commas I want to remove. Here is the result when I try Mid(Replace....)