I want to separate the words in the line word by word or to separate the irregular words with a character space, thus removing the irregularities in the text. I’ve searched the forum a lot but couldn’t find a solution that matches exactly.
Example : " KurzinfoLeistungen und ErzeugnisseBauleistungen "
after editing : " Kurzinfo Leistungen und Erzeugnisse Bauleistungen "
A general solution is required, since all data is a combination of different words. There is no specific reference word.
Is the uppercase character an indicator of where to insert a blank character before ?
If so, you could use a string manipulator with the following regex instruction:
regexReplace( $column1$, "([A-Z])", " $1")
Hope this helps.
Thanks for the answer. It will be a reference for me to find a solution.
Thank you @umutcankurt !
Glad to help you any time
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.