I have a multiline text field that contains SKUs (letters, numbers, and hyphens).
I want a character count of this field. How is this accomplished?
If the hyphens are a problem, I can account for them separately and a letter/number count would still be extremely helpful.
I want a character count of this field. How is this accomplished?
If the hyphens are a problem, I can account for them separately and a letter/number count would still be extremely helpful.
 770 Points
Posted 10 months ago
 1,386 Points
Hello, the function is length. Let me know if this helps.
Length([Text Field])
Length([Text Field])
 770 Points
Thank you for your response. This is definitely getting me closer.
More context for my exact goal  my users paste in values like the ones below.
299450059 596760001 596760000 596760003
 Each 10character string represents a different product.
 I want to figure out how many they pasted in.
 The example above should return "4".
My plan was to get a character count and divide by 10 (since there are 10 characters in each product code). The Length function includes extra characters (not sure if they are spaces or line breaks) which is messing this up.
Any way to get rid of extra characters? Or just count the hyphens?
I really appreciate help.
More context for my exact goal  my users paste in values like the ones below.
299450059 596760001 596760000 596760003
 Each 10character string represents a different product.
 I want to figure out how many they pasted in.
 The example above should return "4".
My plan was to get a character count and divide by 10 (since there are 10 characters in each product code). The Length function includes extra characters (not sure if they are spaces or line breaks) which is messing this up.
Any way to get rid of extra characters? Or just count the hyphens?
I really appreciate help.
 1,386 Points
You can use Length(Trim([Text Field])) but that only takes out the extra spaces in my experience.
If you assume that the length is always a 10 character string plus a delimiter, you can still take your total and divide by 10 and round down.
Ceil(Length(Trim([Text Field]))/10)
This way, in your example the total would be 43 characters total, divided by 10 to get 4.3, rounded down to 4.
Does this help?
If you assume that the length is always a 10 character string plus a delimiter, you can still take your total and divide by 10 and round down.
Ceil(Length(Trim([Text Field]))/10)
This way, in your example the total would be 43 characters total, divided by 10 to get 4.3, rounded down to 4.
Does this help?
Related Categories

Formulas & functions
 2999 Conversations
 79 Followers

Ask about Quick Base functionality
 937 Conversations
 66 Followers