No. of characters in a string

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

3 Likes

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

3 Likes