I need help with this:
i have a list with book-titles e.g.
Wempen,.Faithe.-.No.018.15.-.Office.-.2016.For.Seniors.For.Dummies
I want to replace all "." (dots) with " " space exept the dots between 2 digits should remain
so in my example the result should be:
Wempen, Faithe - No 018.15 - Office - 2016 For Seniors For Dummies
my first step solution:
Code: Select all
OutNameNoExt:= RegExReplace(OutNameNoExt, "[.]", " ")
Wempen, Faithe - No 018 15 - Office - 2016 For Seniors For Dummies
that works so far ... but the partial result "018 15" is not wanted
what should i have to add to match, that the dots between 2 digits remain
pls help
greetz
Max