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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

BCLS776 8,994 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
jharville on at

Like (1)

Report

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

Was this reply helpful? Yes No