How to remove the first and last character of a string of text inside of a collection

(0) Share

Report

Posted on by jharville

Hello all,

I have the following code to create an "Info" collection with a column called "AttributesNew" :

The issue I'm having is under my "AttributesNew" column, the text it results in has a "," in the beginning and end of the string of text. Here's an example of an output it'd give:

,one,two,three,four,five,

I'd like to remove the first both the first and last comma of that string of text so that the output is this:

one,two,three,four,five

How would I modify my existing code to account for this functionality? I've messed around with using the Left() and Len() function but no luck as of yet.

Thank you!

Categories:

Connecting to Data

Using Apps Using Formulas

General Questions

Mobile App

All responses (2)

Answers (1)

jharville on at

Like (1)

Report

Re: How to remove the first and last character of a string of text inside of a collection

Sometimes I look at code so long that I don't see the extreme obvious lol. Thank you for your help!
Verified answer

BCLS776 8,988 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to remove the first and last character of a string of text inside of a collection

Your code looks like it is adding those commas for you - see circled expressions. Remove those and those extra commas should disappear: