Delete extra blank characters in the text and convert them into single spaces or make them standard text

Hi;
Delete extra blank characters in the text and convert them into single spaces or make them standard text

example text Can you help me to add a sample stream or a method to delete the extra and unnecessary null characters in this text as follows and make them into single spaces?

dot “.” Think of the places represented by

sample

"Hello how …are you, how was your…day. The weather …is nice but …I’m very… busy. "

post editing

“Hello how are you, how was your day. The weather is nice but I’m very busy.”

Hi Umut,

The String Manipulation node and this expression should work for you:

regexReplace($column1$, "\\s+", " ")

:blush:

4 Likes

thanks armin; for solution :+1:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.