Problem: I am trying to import data into Google Sheets, but the cell can only hold 50000 characters.
Desired Solution: Set up a router/filter based on my “Match Pattern Parser” being less than 50k characters.
Question: I can’t seem to get the filter to work correctly. My condition is to take the parsed data and see if the array length is greater than 50000. The second path is for everything under 50k but nothing is going through. What am I doing wrong?
I found the answer myself.
You need to use the String function “Length” to convert it into a number. Then you use the Numeric Operator. For this example, I used greater than.
Glad to know that your issue is resolved.
Regards,
Msquare Automation - Gold Partner of Make
Explore our YouTube Channel for valuable insights and updates!
Welcome to the Make community!
Excellent first question and answer!
By the way, you can split long text into smaller lengths using the built-in substring function.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
parseDate | Tokens for formatDatesamliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!