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

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

[BCLS776 · Accepted solution]

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

[jharville]

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