Regex for replacing a single-quote with two single-quotes

Question

I'm running into an issue that I think is being caused by needing to double-up on some single quotes inside a string. However, JS's string.replace uses RegEx, and I've never built a RegEx by hand.

Can someone help me build a RegEx to find a single quote and replace it with two single quotes?

Answer 1

Try this:

yourstring = yourstring.replace(/'/g, "''") 

Answer 2

You don't need to use RegExp.

String patterm version:

str.replace("'", "''", 'g') 

RegExp pattern version:

str.replace(/'/g, "''") 

Here you have some useful RegExp links:

• RegExp Tutorial
• Regular Expression Basic Syntax Reference
• RegExp Build&Testing Online Tool