Regex Split seperated by one or more character

Hello,
i have a coloum with some text in it. the text is seperated by one or more character of e.g. .
How can i split this column in x new ones.

…sometext.sometext.sometext.sometext
.sometext.sometext.sometext
.sometext…sometext.
…sometext…
.sometext

Greetings

The Cell Splitter does exactly that. Delimiters can be single characters or strings, but apparently not RegEx. Is that enough for you?


regex split.knwf (11.3 KB)

2 Likes

Hi @Thyme ,
thanks, i can use the cell splitter.

I thought there was a more elegant solution :slight_smile:

Greetings…

1 Like