Select all single quotes in regex field

Question

I have this field in my JSON data:

"pinyin": "bei1 'ai1",

I just want to select any single quote ' like the one before ai1;

I tried this

(?<="pinyin": "\w*)\'+(?!")

but it didn't work

Have a look at this post https://stackoverflow.com/a/2973495/11954025 — Daniel, Oct 28 '21 at 03:29

score 1 · Accepted Answer · answered Oct 28 '21 at 07:04

You can use

(?<="pinyin": "[\w\s]*)'(?!")

See this regex demo. Details:

(?<="pinyin": "[\w\s]*) - a positive lookbehind that matches a location that is immediately preceded with "pinyin": " and then any zero or more word or whitespace chars
' - a single quotation mark
(?!") - a negative lookahead that fails the match of there is a " char immediately to the right of the current location.

1 Answers1