Hi,
I have a string with multiple words in it, and the string contains more than 50 characters. I need the characters in the column to be less than 50 chars.
If the chars is more than 50, then I need the words after 50chars to be moved in a new column. How will I do that?
Hello @jepavila
You can test to insert a pipe [ | ] with ‘String Manipulation’ node with the following regexReplace()
regexReplace($text$, "(?:([\\S\\s]{1,50}))", "$1|")
And then a ‘Cell Splitter’ with pipe as delimiter.
BR
Hi @jepavila
A very similar question was asked and solved in the following topic:
Maybe this is the solution you are looking for and it helps.
Best
Ael
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
