I have a scenario that sends emails from Gmail to Slack. Is there a way to limit the email body to a specific number of characters? The messages are too long. I only require the first 50 words or approximately 250 letters from the email body for my needs.
You can use substring function to achieve this. Basically something like this,
substring(yout_email_text;0;250)
1 Like
Also, If you want to use word count instead of letters, what you can do is use join, split and slice function,
join(slice(split(your_email_text; space);0;50);space)
For the space, use the option available in the text mapping section.
1 Like