Formula to count values in a field
I have a multi-line text field that clients use to input various Skus or Barcode values. The values can be scanned in or copy/pasted using various delimiters (comma, enter, space). I need another fiel...
Forum Discussion
Hi Rebecca,
So currently your clients are entering or putting in all of these SKUs and they aren't using one set delimiter? So it could be a comma, a space, or other character? There isn't anything consistent to help identify one entry from another?
So currently your clients are entering or putting in all of these SKUs and they aren't using one set delimiter? So it could be a comma, a space, or other character? There isn't anything consistent to help identify one entry from another?
- Not currently. If forcing them to use one delimiter would allow me to solve for a count of the values entered, then I could make that sacrifice.
- Hi Rebecca,
I was going to say something similar to what Mark posted below, it is going to require a pretty long formula to check on all of those different fields but it is possible to build out so long as you have a reliable breaking character to read off of. In his example he is doing it off of /n but alternatively it could be off of a ; or : between each entry. A reliable delimiter would allow you to utilize a formula like this. Then the Count will add up all the non blank Part entries. - ... my formula will break on a space, or a comma or surprisingly the carriage return (new line) character.
- I have been starring at enough formulas today I didn't even see that comma in there at first glance.
