Re: Converting text into CSV format

[Jim Straus]

Assuming it is always 4 lines: Search: ([^\t]*)\n(.*)\n(.*)\n(.*)\n Replace: \1\t\2\t\3\t\4\n The first part captures the total contents of the four lines. (The first pattern [^\t]* says only lines without tabs, just to make sure the wildcard doesn’t try to grab the newly generated line) The second replaces those four lines with a tab separated line -Jim Straus On Oct 29, 2024, at 6:06 AM, Howard <leadwithlo...@gmail.com> wrote: 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 "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/bbedit/71480dfc-9aaa-48d4-b47d-771a01fcda30n%40googlegroups.com. -- 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 "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/bbedit/E1123EF1-11DD-4BD1-A4D7-0777CEE04863%40gmail.com.