How to add single quote “ ' ”at beginning and end of an 5 pos integer

Question

I need to add a single quote at the begining and end to a 5 position integer field in TextPad.

Ex:

14982
14983
14985
14991
14995
15019

Desired result:

'14982',
'14983',
'14985',
'14991',
'14995',
'15019'

Answer 1

Just use the search-and-replace function:

1. Check the regex box
2. Use \(\d\d\d\d\d\)  as the source (you can also use \(\d{5}\) )—space at the end
3. Use '\1',  as the target (again a space at the end)
4. Replace all
5. Delete the extraneous ,  at the end of the line(s):
   • Manually if there’s a few
   • Using regular expressions if there’s a lot:
     1. Check the regex box
     2. Use , $ as the source
     3. Use an empty field for the replacement text
     4. Replace all

Answer 2

Replace \(\<[0-9]\{5\}\>\) (words consisting of exactly five digits) with '\1', and then ' ' with ', '.

Answer 3

Two steps: 1.For the first "'" (single quote), put ^ on Find What text box and ' on the Replace with text box. 2. for the second "'" (single quote) and ", " , put $ on Find What text box and ' , on the Replace with text box. 'D4881', 'D2243', 'G7051', 'X9767', 'D3040',