Hi Rick Many thanks for the explanation, I can see what you mean now.
Regards Dave On Thursday, June 8, 2023 at 5:53:09 AM UTC+1 Rick Gordon wrote: > It can be adapted for 2-10 words; it's just along expression. > > As you can see, what I provided… > > === > 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 > === > > …has one instance of *(\w+)* followed by 2 instances of *(\h\w+)* > followed by *(?=\h\w+$))* in the segment before the first vertical bar, > while the segment after the first vertical bar is the same, but contains > 3 instances of *(\h\w+)*. > > So what needs to be done is to add more segments, each separated by a > vertical bar except for the last one (since the vertical bar means "OR"). > > To clarify, the *(?:^2 PLAC(?: \d+) \K* processes and ignores the the > start of the line… > > *2 PLAC*, followed by an optional set of digits preceded by a space, > followed by a space. > > So it's just a question of stacking more instances, one with only one > *(\h\w+)*, for the shortest possibility, and the rest with yet an > additional instance of *(\h\w+)* , separating each with a vertical bar. > > Rick Gordon > > -------- > > On June 7, 2023 at 9:37:27 PM [-0700], Dave Simpson wrote in an email > entitled "Re: Replacing all spaces in a line, but not the first": > > 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 > > < > 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://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 > > < > 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://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://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 > > < > 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://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 > > < > 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] > > <mailto:[email protected]>. > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/bbedit/58bab2c5-8ca6-450c-9ed4-bba2df3af9f9n%40googlegroups.com > > > < > https://groups.google.com/d/msgid/bbedit/58bab2c5-8ca6-450c-9ed4-bba2df3af9f9n%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/9ccb909d-97c4-4e59-9e10-f2b62bf33089n%40googlegroups.com.
