![]() |
|
|
Thread Tools | Display Modes |
#3
|
|||
|
|||
![]()
Thanks for your reply Paul. I am afraid your code doesn't work. As I understand it:
The "find" expression translates ^13 is code for the paragraph break - I don't understand the expression or function ^| - or is that a lower case L?. I assume the [0-9]{1,} is to find a numerical string between zero and nine. What is the function of the numeral one in curly brackets? I gather the expression ^32 represents a space. My understanding of the "replace" function is that it replaces the first element in the find expression (i.e. the \1) with a space. I don't want a space, I need a comma after the number represented by the numerical string. The numerical string can be any number (i.e. set of numerals comprising a number, between 1 and 99999. The numbers above 1000 are not comma delineated. The following text is an example of the original document: 641 Beard, Ernest Noel, 31 Tennyson st., S.8, analyst, M 642 Beard, Suzanne Louise, 31 Tennyson st., S.8, sales; F 643 Beasley, Howitt, 72 Beaumaris pde., S.21, foreman, M 644 Beasley, Joyce Ivy, 18 Victory st., S.8, mechanic, F 645 Beaton, Flora Janet, 44 Sims st., S.8, home duties, F I want the result of the macro to produce 641,Beard, Ernest Noel, 31 Tennyson st., S.8,,analyst, M 642,Beard, Suzanne Louise, 31 Tennyson st., S.8, sales; F 643,Beasley, Howitt, 72 Beaumaris pde., S.21, foreman, M 644,Beasley, Joyce Ivy, 18 Victory st., S.8, mechanic, F 645,Beaton, Flora Janet, 44 Sims st., S.8, home duties, F Your advice would be appreciated |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
RPM7 | Word VBA | 6 | 05-12-2017 12:58 AM |
![]() |
cheech1981 | Word | 3 | 03-29-2017 02:33 PM |
How to do multiple find and replace in string. | PRA007 | Word VBA | 2 | 01-06-2016 09:10 PM |
![]() |
errtu | Word | 1 | 01-31-2013 02:09 PM |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |