Re: Converting text into CSV format

[bruce linde]

fastest way?    replace every instance of “Student” with “xxxxxStudent”    replace every line return with “\t” (a tab)    select all and remove line breaks    replace every instance of ”xxxxxStudent” with “\rStudent”    select all, copy, paste into new/blank excel doc    elapsed time maybe 30 seconds    8-) or, wait for actual regex tips and tricks from the gang.   8-) On Oct 28, 2024, at 2:12 PM, Howard <leadwithlo...@gmail.com> wrote: I have this data (a sample below). Each student has four lines of data. I need to convert it into CSV format, so it can work in Excel. How can I do that in BBEdit? I have version 14.6.9. Sample Data Student One 1 0 Oct 06, 2024, 09:31 PM Student Two 1 0 Oct 06, 2024, 08:23 PM Student Three 1 0 Oct 04, 2024, 01:55 PM Picture of data <CSV Data.jpg> -- 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/f428fcca-c84f-4249-8fc3-82ecbcec53e3n%40googlegroups.com. <CSV Data.jpg> -- 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/54D3862A-4257-4658-8829-5BA9B01FE17C%405happy.com.