Count Function

[Sdaddy]

I need to write a function that will count commas inside a memo box. I.E. I have a memo field inside a record that users paste an array of 6 digit numbers all seperated by a comma. I need to count how many 6 digit number sets are inside that memo box and populate it into the same record in the table. Please help!!!!!

 

[mck144]

You want to count the number of commas plus one

a, b, c, d
four items, three commas
counting commas is easier, just add one to the final count and that's your final item count

 

[Sdaddy]

Thanks in advance. I have figured this out. FYI I used a len statement divided it by 7 and added 1

 

[mck144]

You want to count the number of commas plus one

a, b, c, d
four items, three commas
counting commas is easier, just add one to the final count and that's your final item count. you want to count every instance of the character ","