Search code examples
regexdatabasenotepad++phpstorm

Find and replace in DB string

I have a DB file. In that file there are many rows that contain phone number like this : 

"a",93560050,"b"

I want to surround it with "" to have it like this :

"a","93560050","b"

How can I do this?

Solution

  • You only need to search like this:

    (\d{8})

    then you can replace with 

    "\1"

    so you have the quotation.