There are just first and last names, no middle names nor initials. For privacy reasons, I was unable to use the real names. With regard to the numbers, they are not just zeros and ones. Usually, however, they are from 0-5, but can be higher.
Here is revised sample data; *Sample Data* John Doe 4 1 Oct 06, 2024, 09:31 PM Peter Pollard 2 0 Oct 06, 2024, 08:23 PM Cathy Cone 4 3 Oct 04, 2024, 01:55 PM I would like the above data to be easy for me to put into Excel. Here is how I would like the output to be formatted: John Doe, 4,1,Oct 06, 2024, 09:31 PM Peter Pollard,2,0,Oct 06, 2024, 08:23 PM Cathy Cone,4,3,Oct 04, 2024, 01:55 PM In Excel, the names and dates will be formatted as text, and the others as numbers. Thanks, Howard On Monday 28 October 2024 at 6:21:38 pm UTC-4 "Jan Erik Moström" wrote: > On 28 Oct 2024, at 22:56, bruce linde wrote: > > > when you’re asking folks how best to use bbedit to deal with your actual > data, i would suggest posting said actual data… > > Show some example data and the expected output. From what I can see (and > how I interpret the question) it could be a very simple regexp or a more > complex one. > > = jem > -- This is the BBEdit Talk public discussion group. If you have a feature request or believe that the application isn't working correctly, please email "[email protected]" rather than posting here. Follow @bbedit on Mastodon: <https://mastodon.social/@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 visit https://groups.google.com/d/msgid/bbedit/71480dfc-9aaa-48d4-b47d-771a01fcda30n%40googlegroups.com.
