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
