"Length()" operator giving two different results for same text

Hi Community,

I am encountering a weird issue with the Text and Binary Function “Length()”. When I run my scenario so that the “Set Variables” module calculates the total character length of my variable “caption” that is pulled from an Airtable field, it calculates that I have 257 characters even though there are only supposed to be 256. And when I run that exact same module on its own as a test (not part of the scenario) and paste the exact same caption, it returns a character length of 256…

Is there something I am missing here?

INFORMATION
The module setup:

When ran as part of the scenario (caption pulled from Airtable):

When ran only the module (caption text copy/pasted directly into the module):

Welcome to the Make community!

For technical issues or bugs like this, directly contacting support can often lead to a faster resolution. They have access to your specific account details, scenario and scenario logs, server-side logs, and internal tools and resources, which allows them to investigate more thoroughly than what you have access to. Additionally, sharing sensitive information about your account or scenario might not be suitable for an open forum discussion.

You can open a new ticket here, or if you are unable to login for some reason, you can create another new free account to access the ticketing system (which is only available to logged-in users). Alternatively, you should be able to send an email to helpdesk@make.com and support@make.com and it should create a ticket. After submitting a new ticket, you will receive an automatic confirmation email with the subject “Ticket Created” in the subject. If you do not receive this, try sending the ticket again.

If you manage to get your issue resolved with support, we’d still love to hear about it! Sharing your solution on the forum can help others facing similar problems.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Perhaps when you are generating your captions a white space is being added at the end? Try wrapping the text around a trim() function inside lenght()

4 Likes

Sharp mind!
That was exactly the problem (even though in Airtable there weren’t any white spaces).

Thanks a lot for your help :slight_smile:
Alex

2 Likes