Regex Replace

[hi2019]

Hi

I have a Regex formula but I think the punctuation in the column is giving it an extra count - 

is this formula correct?

REGEX_Replace(ReplaceChar([Name Copy], '. ,', '|'), '\|+', '|')

FRHT FIRST CORP. 

it reads it as count 4 but it should be 3

FRHT/FIRST/CORP/   isnt it countig it like this?

I have another one with punctuation but it is reading it correctly 

DID C. REORD count 3 

or could it be because the ending of these column has approx 7-8 spaces after the last letter? It is messy data and  i have a data cleanse tool to remove extra trailing spaces or does it only account for certain amount of spaces?

[CPacheco89]

Thank you very much for this and for providing a simpler option! I'll try it out and provide feedback. I initially thought the RegEx tool would be a good option since I didn't want to remove all the question marks in the texts, but only the ones that should be apostrophes. I appreciate you taking the time to share your knowledge with me.