Find and replace in DB string

Question

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?

Answer 1

You only need to search like this:

(\d{8})

then you can replace with

"\1" 

so you have the quotation.

Answer 2

Because phone mumbers are only numeric and there're no other numbers than phone number, you can do:

• Ctrl+H
• Find what: \d+
• Replace with: "$0"
• Replace all