Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: len() count incorrect due to line breaks

Solved
Jump to Solution
305 0
cancel
Showing results for 
Search instead for 
Did you mean: 
RPA
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Dominic
6 - Interface Innovator
6 - Interface Innovator

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", ""))

 

See Solution in Thread

2 Replies 2
Dominic
6 - Interface Innovator
6 - Interface Innovator

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", ""))

 

RPA
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you! That works perfectly!