But I don't know that using "\."
Yeah, that's one of the differences between Regex and VB string functions.
Regex uses patterns rather than plain literal strings.
In those patterns, the full stop "." character has a special meaning, just like asterix "*" has special meaning in filenames.
So to use an actual full stop as a delimiter, you need to tell Regex to treat it as a normal full stop character, and not with the special meaning.
To do that, you "escape" the character from the special meaning by putting a backslash "\" in front of it.
The backslash tells Regex to treat the next character just as a normal character, without any special meaning.
Patterns are nice - for example, if you split a date using pattern [\ \-\/\.] then it will handle dates like 25.12.2024 and 24-12-2024 and 25/12/2024 and 25 12 2024.
But they are not quite as simple as plain literal strings. You have to know about escaping certain characters.
I just escape everything that's not alpha-numeric, rather than try remember which characters have special meaning and which don't.