cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DTooley
Level: Powered On

Count the number times a specific character appears in a text field

I have a multi-line text field where the data is delimited by commas.  The field can contain from 1-32 items.  Example: Chicago, Boston, Seattle.  I need to determine the number items in the field (in the example it is 3). 

 

I tried using split with a variable counter:   split(variables('Locations'),',')[variables('varIndex')]  This split sits in a DoUntil loop that increments varIndex by one.  However, when the index count exceeds the number of items, I get an error of 'out of bounds array index'.

 

How can I get a count of the commas or the items?  If I know the count beforehand, I can set the DoUntil to stop before it tries the split and throw the error.

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Count the number times a specific character appears in a text field

Have you tried the following to get the length of your array?
length(split(variables('Locations'),','))

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Count the number times a specific character appears in a text field

Have you tried the following to get the length of your array?
length(split(variables('Locations'),','))

View solution in original post

Highlighted
DTooley
Level: Powered On

Re: Count the number times a specific character appears in a text field

Pieter,

That worked perfectly.  Thank you very much!!

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,209)