Hi Rick Many thanks for that, it works a treat (within limits)!
When I say that, it works fine for lines where the address is 4 elements long. e.g. *2 PLAC 49 Spinney Close Northfield Birmingham* converts to *2 PLAC 49 Spinney, Close, Northfield, Birmingham* However if there are fewer or more elements it ignores the line. A PLAC entry can be in the range 1 to 10 elements e.g. * 2 PLAC 46 Norton Crescent Alum Rock Birmingham *has 5 elements and is ignored as is *2 PLAC Kalamzoo Birmingham *which is 3 elements I'm beginning to think that I'm asking too much, as a PLAC entry can be in the range 1 to 10 elements *Having just written that, a solution came to mind:* If I change the Replace statement to* \1,\2,\3,\4,\5,\6,\7,\8,\9,\10 *that will put superfluous commas in place e.g. *2 PLAC 33 Barker, Street, Shrewsbury,,,,,,, Shropshire* However, it is a simple matter to remove the extra commas. I can fix the things like Street, Road etc afterwards, it was the initial adding of the commas that was giving me a problem. Very many thanks for your efforts Dave On Wednesday, June 7, 2023 at 9:24:02 PM UTC+1 Rick Gordon wrote: > Try this: > > === > FIND: > (?:^2 PLAC(?: \d+) \K(\w+)(\h\w+)(\h\w+)(?=\h\w+$))|(?:^2 PLAC(?: \d+) > \K(\w+)(\h\w+)(\h\w+)(\h\w+)(?=\h\w+$)) > > CHANGE TO: \1,\2,\3,\4 > === > > That should ignore the first number and handle groups of either 3 or 4 > words afterwards. It could be further modified if longer groups are > possible. > > It doesn't handle street names in the most intelligent way, as it will > put a comma after the street name. And if any words had punctuation in > them (like "St.", or a hyphen), that would require further modification. > > Rick Gordon > > ---------- > > On June 7, 2023 at 1:18:08 PM [-0700], Dave Simpson wrote in an email > entitled "Re: Replacing all spaces in a line, but not the first": > > Hi Kaveh > > > > I'm not sure that that would solve it. > > > > It first needs to find the lines beginning with "2 PLAC " and act only > > on those lines. > > Replacing "2 PLAC " with something else would give the same issue, it > > would have to find only those lines beginning with our substitute label. > > > > Many thanks for your help. > > Think I'll put it on the back burner for now. > > > > Regards > > Dave > > On Wednesday, June 7, 2023 at 8:52:23 AM UTC+1 Kaveh Bazargan wrote: > > > > Ah, I thought all lines had that. > > > > Then you could replace "2 PLAC " (with space) with a unique > > string, e.g. ●, and at the end replace ● by "2 PLAC " > > > > Not sure that would solve it. > > > > On Tue, 6 Jun 2023 at 19:02, Dave Simpson <[email protected]> wrote: > > > > Hi Kaveh > > Sorry about the delay in replying, had to go out. > > I’m a bit confused as to how the 2 PLAC can be put back to > > correct line > > > > Not every line in the file begins with 2 PLAC > > > > Dave > > > > On Tuesday, June 6, 2023 at 4:29:21 PM UTC+1 Kaveh Bazargan wrote: > > > > BTW to replace > > > > 2 PLAC > > > > at start of lines when replacements have been done, replace: > > > > "^" -- start of line > > with > > > > "2 PLAC " > > > > On Tue, 6 Jun 2023 at 15:28, Kaveh Bazargan > > <[email protected]> wrote: > > > > Simplest might be first to remove all "2 PLAC " > > > > Then replace > > "(?<!(?:[0-9]))" > > with > > ", " > > > > So replace any space not preceded by a digit to a > > comma space. > > > > Would that work? > > > > On Tue, 6 Jun 2023 at 15:19, Dave Simpson > > <[email protected]> wrote: > > > > Hi Kaveh > > > > No problem, 3 examples of before and after > > > > 2 PLAC 129 Haymarket London England > > 2 PLAC 129 Haymarket, London, England /[Ideal > > answer because space between '129' and 'Haymarket' > > is skipped, but not essential]/ > > > > 2 PLAC 24 Long Street Chester Cheshire > > 2 PLAC 24, Long, Street, Chester, Cheshire > > > > 2 PLAC Meadows, Lowestoft, England > > 2 PLAC Meadows Lowestoft England > > > > Thanks > > On Tuesday, June 6, 2023 at 2:48:07 PM UTC+1 Kaveh > > Bazargan wrote: > > > > Hi Dave > > > > Could you give several examples of before, > > then the same ones after? > > > > Regards > > Kaveh > > > > On Tue, 6 Jun 2023 at 14:45, Dave Simpson > > <[email protected]> wrote: > > > > Hi, I'm a novice at this sort of thing. > > > > I have a line of text:- > > /2 PLAC 11 Haymarket Willenhall Staffordshire/ > > > > I want to replace the spaces with , > > [comma space] after the first part of the > > line [2 PLAC ] > > > > ^(2 PLAC ) finds me the start > > Now I want to replace the spaces with > > comma space:- > > > > /2 PLAC 11, Haymarket, Willenhall, > > Staffordshire/ > > [It would be brilliant if it were possible > > to skip the first space between 11 and > > Haymarket] > > / > > / > > Many thanks for your help > > > > -- > > This is the BBEdit Talk public discussion > > group. If you have a feature request or > > need technical support, please email > > "[email protected]" rather than posting > > here. Follow @bbedit on Twitter: > > <https://twitter.com/bbedit> > > --- > > You received this message because you are > > subscribed to the Google Groups "BBEdit > > Talk" group. > > To unsubscribe from this group and stop > > receiving emails from it, send an email to > > [email protected]. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/bbedit/8ef6eae3-ca41-4f50-bf72-c4394a8fee8fn%40googlegroups.com > > < > https://groups.google.com/d/msgid/bbedit/8ef6eae3-ca41-4f50-bf72-c4394a8fee8fn%40googlegroups.com?utm_medium=email&utm_source=footer > >. > > > > > > > > -- > > Kaveh Bazargan PhD > > Director > > River Valley Technologies > > <http://rivervalley.io> ● Twitter > > <https://twitter.com/rivervalley1000> ● > > LinkedIn > > <https://www.linkedin.com/in/bazargankaveh/>● > > ORCID <https://orcid.org/0000-0002-1414-9098> > > ● @[email protected] > > <https://mastodon.social/@kaveh1000> > > *Accelerating the Communication of Research* > > *< > https://www.linkedin.com/posts/bazargankaveh_ismte-innovation-award-recipient-kaveh-bazargan-activity-7039348552526921728-XAEB/?utm_source=share&utm_medium=member_desktop > > > > > https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/ > > < > https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/ > > > > * > > > > -- > > This is the BBEdit Talk public discussion group. > > If you have a feature request or need technical > > support, please email "[email protected]" > > rather than posting here. Follow @bbedit on > > Twitter: <https://twitter.com/bbedit> > > --- > > You received this message because you are > > subscribed to the Google Groups "BBEdit Talk" group. > > To unsubscribe from this group and stop receiving > > emails from it, send an email to > > [email protected]. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/bbedit/34efcbe2-6182-4ce7-a737-900da7c534can%40googlegroups.com > > < > https://groups.google.com/d/msgid/bbedit/34efcbe2-6182-4ce7-a737-900da7c534can%40googlegroups.com?utm_medium=email&utm_source=footer > >. > > > > > > > > -- > > Kaveh Bazargan PhD > > Director > > River Valley Technologies <http://rivervalley.io> ● > > Twitter <https://twitter.com/rivervalley1000> ● > > LinkedIn <https://www.linkedin.com/in/bazargankaveh/>● > > ORCID <https://orcid.org/0000-0002-1414-9098> ● > > @[email protected] > > <https://mastodon.social/@kaveh1000> > > *Accelerating the Communication of Research* > > *< > https://www.linkedin.com/posts/bazargankaveh_ismte-innovation-award-recipient-kaveh-bazargan-activity-7039348552526921728-XAEB/?utm_source=share&utm_medium=member_desktop > > > > > https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/ > > < > https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/ > > > > * > > > > > > > > -- > > Kaveh Bazargan PhD > > Director > > River Valley Technologies <http://rivervalley.io> ● > > Twitter <https://twitter.com/rivervalley1000> ● LinkedIn > > <https://www.linkedin.com/in/bazargankaveh/>● ORCID > > <https://orcid.org/0000-0002-1414-9098> ● > > @[email protected] <https://mastodon.social/@kaveh1000> > > *Accelerating the Communication of Research* > > *< > https://www.linkedin.com/posts/bazargankaveh_ismte-innovation-award-recipient-kaveh-bazargan-activity-7039348552526921728-XAEB/?utm_source=share&utm_medium=member_desktop > > > > > https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/ > > < > https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/ > > > > * > > > > -- > > This is the BBEdit Talk public discussion group. If you have a > > feature request or need technical support, please email > > "[email protected]" rather than posting here. Follow > > @bbedit on Twitter: <https://twitter.com/bbedit> > > --- > > You received this message because you are subscribed to the > > Google Groups "BBEdit Talk" group. > > To unsubscribe from this group and stop receiving emails from > > it, send an email to [email protected]. > > > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/bbedit/293f45d2-3ed3-44d0-891f-fc32d61df2f3n%40googlegroups.com > > < > https://groups.google.com/d/msgid/bbedit/293f45d2-3ed3-44d0-891f-fc32d61df2f3n%40googlegroups.com?utm_medium=email&utm_source=footer > >. > > > > > > > > -- > > Kaveh Bazargan PhD > > Director > > River Valley Technologies <http://rivervalley.io> ● Twitter > > <https://twitter.com/rivervalley1000> ● LinkedIn > > <https://www.linkedin.com/in/bazargankaveh/>● ORCID > > <https://orcid.org/0000-0002-1414-9098> ● @[email protected] > > <https://mastodon.social/@kaveh1000> > > *Accelerating the Communication of Research* > > *< > https://www.linkedin.com/posts/bazargankaveh_ismte-innovation-award-recipient-kaveh-bazargan-activity-7039348552526921728-XAEB/?utm_source=share&utm_medium=member_desktop > > > > > https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/ > > < > https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/ > > > > * > > > > -- > > This is the BBEdit Talk public discussion group. If you have a feature > > request or need technical support, please email > > "[email protected]" rather than posting here. Follow @bbedit on > > Twitter: <https://twitter.com/bbedit> > > --- > > You received this message because you are subscribed to the Google > > Groups "BBEdit Talk" group. > > To unsubscribe from this group and stop receiving emails from it, send > > an email to [email protected] > > <mailto:[email protected]>. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/bbedit/8df13542-9166-43a7-998e-8bdc7090cea1n%40googlegroups.com > > > < > https://groups.google.com/d/msgid/bbedit/8df13542-9166-43a7-998e-8bdc7090cea1n%40googlegroups.com?utm_medium=email&utm_source=footer > >. > > ___________________________________________ > RICK GORDON > EMERALD VALLEY GRAPHICS AND CONSULTING > ___________________________________________ > WWW: http://www.shelterpub.com > -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/58bab2c5-8ca6-450c-9ed4-bba2df3af9f9n%40googlegroups.com.
