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
Rebecca,
Here is a formula for up to 5, but you would need a lot of repetition to get it to count to 250! I would suggest testing with say 5 or 10 to see if it would work for how your staff paste.
var Text parta = Part([paste target], 1, "\n ,");
var Text partb = Part([paste target], 2, "\n ,");
var Text partc = Part([paste target], 3, "\n ,");
var Text partd = Part([paste target], 4, "\n ,");
var Text parte = Part([paste target], 5, "\n ,");
Count(
$parta<>"",
$partb<>"",
$partc<>"",
$partd<>"",
$parte<>"")
Here is a formula for up to 5, but you would need a lot of repetition to get it to count to 250! I would suggest testing with say 5 or 10 to see if it would work for how your staff paste.
var Text parta = Part([paste target], 1, "\n ,");
var Text partb = Part([paste target], 2, "\n ,");
var Text partc = Part([paste target], 3, "\n ,");
var Text partd = Part([paste target], 4, "\n ,");
var Text parte = Part([paste target], 5, "\n ,");
Count(
$parta<>"",
$partb<>"",
$partc<>"",
$partd<>"",
$parte<>"")