I thought about this before but couldn’t solve it. You’re right, the records all start (in this file) with 200 BUT not all recs end with two consecutive semi-colons (the ERROR-MESSAGE is the last and I have recs with ERROR-MESSAGEs <> ‚‘).
> Am 26.03.2025 um 16:04 schrieb Bruce Van Allen <[email protected]>: > > Another way staying in BBEdit would be to do some neutralizing conversions > before parsing into columns. > > For example, when I need to embed newlines in a file of text records whose > records are separated by newlines, I replace the internal newlines with > another character that isn’t already in the records somewhere - such as a > backslash (‘\’). It looks like your records all start with ‘200' and end with > two consecutive semi-colons (‘;;’). If so, then you could search for newlines > NOT surrounded by those. > > When I do this I take a step and then save a copy of the file before moving > to the next cleanup step. Always want to be able to back up a step or two if > I goof. > > [Sorry about the stupid smart quotes my new email client insists on > converting from straight quotes.] > > HTH > > ------ Original Message ------ > From "Marshall Clow" <[email protected] <mailto:[email protected]>> > To [email protected] <mailto:[email protected]> > Date 3/26/2025 7:41:47 AM > Subject Re: How to filter / sort CSV-files by certain columns? > >> On Mar 26, 2025, at 7:25 AM, Vlad Ghitulescu <[email protected]> wrote: >>> >>> You’re probably right re BBEdit vs other special tools - even Rich >>> suggested this in the beginning of our conversation. >>> >>> The question is: Which other tool exactly? >>> >>> Excel would not import 3 million+ records 😔 and yes, I encountered the >>> „helpful“ changes and some more too 😶 >>> >>> The Perl-CSV family of modules sounds like heaven 😉 - unfortunately I >>> didn’t learn Perl yet 😶 >> >> I have done stuff with the ’csv’ module in python 3, but nothing this >> extensive. >> https://docs.python.org/3/library/csv.html >> >> — Marshall >> >> > > > Thanks, > > - Bruce > > _bruce__van_allen__santa_cruz__ca_ > > > -- > 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/em3a519c56-ef50-4ccb-bcfb-de55aeab4fd2%40181c06df.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 "[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/095CF47A-233D-44A0-81BA-B737E431CBE8%40Ghitulescu.de.
