Every had a day when you realise that you've been a total Muppett? If I process all the lines beginning "2 PLAC " and add the commas in front of every space, it will convert "2 PLAC " to "2, PLAC, " So then I just need to do a pass to convert "2, PLAC, " back to "2 PLAC "
The only bugbear with that is that it puts a comma after the house number, whereas Rick's method doesn't,but I can fix that. Many thanks On Wednesday, June 7, 2023 at 10:34:25 PM UTC+1 Dave Simpson wrote: > 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/74b2d0c3-668d-46c8-a6d2-defcc997d3f2n%40googlegroups.com.
