CODEWITHSUNDEEP
notepad++
MartinKalco
MartinKalco

Reputation: 62

Remove single quotes on number notepad++

Hi i have one file with 3600+ line and different numbers in single quotes and i want to remove single quotes ex.

'1438115887' '192' '143854321' '17' '321122'

This is full line

(27, 'user', '[email protected]', '', '', 1, 0, 'Europe/London', 1, 2, '', 2, 6, '61', 0, '1424716755', '1437805182', 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 4, 0, 0, 1),

Can i remove ' ' from all number? I try with ^\d+ but not effect.

Thank you

Upvotes: 0

Views: 2727

Answers (2)

AdamF
AdamF

Reputation: 2601

Use Find and Replace with two regular expressions:

  1. find: '(.\d) replace: \1
  2. find: (.\d)' replace: \1

It might not work if the email starts with digit.

Edit:

Better solution in one Find and replace: Find: '(.\d+)' and replace: \1

Upvotes: 2

dudeman
dudeman

Reputation: 1136

I think find and replace should work perfectly. Just find ' and replace it with nothing.

Upvotes: -1

Related Questions