Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 23, 2024 09:26 AM
We have formulas to check character counts and they're returning with "over character count" for long text that is actually not over character count because they're adding characters for line breaks. Is there a way to adjust the formula to not include line breaks as a character?
For example, this would return 338:
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ac magna volutpat, pretium arcu non, ullamcorper erat. Donec dictum eros in tellus elementum sollicitudin. Morbi sit amet justo purus. Phasellus interdum eros eu quam euismod, sed efficitur lorem fermentum. Sed neque metus, dapibus at sapien at, pellentesque placerat ipsum.
But the same text with line breaks would return 342 and if the character count formula were set to 340, would show as over cc:
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Fusce ac magna volutpat, pretium arcu non, ullamcorper erat.
Donec dictum eros in tellus elementum sollicitudin. Morbi sit amet justo purus. Phasellus interdum eros eu quam euismod, sed efficitur lorem fermentum.
Sed neque metus, dapibus at sapien at, pellentesque placerat ipsum.
Solved! Go to Solution.
Aug 23, 2024 11:06 AM
Hi RPA,
If you are using LEN() then you should be able to modify the formula to remove the line breaks. Something like this should work:
LEN(SUBSTITUTE({Text}, "\n", ""))
Aug 23, 2024 11:06 AM
Hi RPA,
If you are using LEN() then you should be able to modify the formula to remove the line breaks. Something like this should work:
LEN(SUBSTITUTE({Text}, "\n", ""))
Aug 23, 2024 11:41 AM
Thank you! That works perfectly!