Nov 12, 2016 07:19 AM
Has anyone worked out how to use the COUNT function to count the number of characters in a text string?
Feb 20, 2019 01:58 PM
@Diogo_Nogueira could you share your solution?
Feb 20, 2019 07:20 PM
Look at the reply by Gareth (above) for a solution.
Feb 20, 2019 07:42 PM
@Justin_Barrett When I tried that I got an error message.
Feb 20, 2019 08:29 PM
@Kaiti_Hill Looks like the quotes in the version above got mangled somehow. Some are straight, others are curled. Try copying this, which is the fixed version that I tested successfully:
LEN(Name)-LEN(SUBSTITUTE(Name," ","")) + 1
Feb 20, 2019 08:31 PM
@Justin_Barrett you are WONDERFUL. thank you so much!!
Aug 09, 2019 09:51 AM
So, I’m trying to come up with a way to complicate this and I believe I have found it. I have an ever changing array of characters that can be sequential but may not be (A, B, C, D, F… etc.) and I want to count the occurrence of each one in a much longer array (AAACCCBBDDIIFFIAAHDICCHAIKLA… etc.). I have my base structured such that one field (Field 1) keeps track of my changing array like above, and another field (Field 2) that keeps up with a concatenated larger array. Any one have any ideas on counting each character from Field 1 in Field 2?
Thanks!
Aug 09, 2019 07:23 PM
To pull that off, the software needs some way to iterate through both arrays. Airtable isn’t built for any kind of iteration…yet. I’m confident that this will be possible someday, but today isn’t that day. Sorry.
Aug 12, 2019 09:45 AM
Thanks for the reply Justin. I have been racking my brain to come up with an iteration work around, without using an API (mostly because I’m not yet knowing how to write/implement an API).