ultraedit find quote and replace

Question

I have a row that looks like this:

'ABCD','ABKCKD','ADFL','3','43

In UltraEdit, I am trying to find '3',' and replace that as 3, I tried to find as ['][\d]+['][,]['] and found '3','

However, when I tried to replace it as [\d]+[,], it doesn't work.

Any ideas?

Thanks.

Answer 1

You first need to capture the number between the quotes, you can do it like this using capturing group ():

'([\d]+)','

then use the captured digit using ^1 so your replace would be : ^1,

Ultraedit regex usage reference