The easiest way to take the dots out would be to select all the dot affected files, then, in the tag window, click to edit the filename (name) field. If it's not there, add it by right click > also show.
Note: The leading "=" sign is extremely important. Ctrl+Z (Undo) will be your friend if things are not right.
While in edit mode, replace "Varies" with: =replace([filename (name)],.,) and press enter.
The dots will be removed.
If you want to replace the dots with spaces, then use: =replace([filename (name)],.,/ )
If you want to trim characters from the start or end, to remove the "The " for example, use: =removeleft([filename (name)],4)
If you used "removeright", then the word "Club" would be removed, leaving a trailing space at the end.
How useful this stuff is depends on how big the job is, and how many files fit the given rule. If you have one hundred files you wish to remove dots from, this will do it in the blink of an eye. If those same hundred files all have different numbers of characters to strip from the front, then it would be a tedious job to go through them applying this logic to each file individually. If the above tips are enough, super, if not, we'll need more info regarding the current state of things, your desired goal, and the number of files involved.
-marko.