RXReplace: Invalid escape sequence: "\B".

[Lucas Tarquino]

I'm trying to add a calculated column to create abbreviations for a stringusing a regular expression in the RXReplace function:RXReplace([Hospital_Name],"B[a-zA-Z'-]+","","g"). However, I get an error stating "Invalid escape sequence: "B"." which seems to not recognize the not word boundary. The function does recognize the word boundary "b". Why is this not working Is there an alternative to "B" or a different approach to abbreviate a phrase (e.g., "This Is A Phrase" > "TIAP")

[Lucas Tarquino]

Please see the following StackOverflow post for the question and answer https://stackoverflow.com/questions/55415866/rxreplace-function-gives-in....

The correct function call is: RXReplace([Hospital_Name], "\B[a-zA-Z'-]+|\W+", "", "g").

[Gaia Paolini]

Thanks for cross-linking!