On 28 Sep 2021, at 19:04, Kim Mosley <mrkimmos...@gmail.com> wrote:
> I'm looking for a grep pattern to put this data into 5 columns (though there
> is no data for the "tags" column). Hopefully I can paste it into Excel. Now
> it just goes into one column.
Save this script as xx.pl in
"~/Library/Application Support/BBEdit/Text Filters/",
bring your document to the front and run the filter from the palette (Menu:
Window::Palettes::Text Filters.)
If you want to see the output without modifying the file, run the same script
from the Scripts palette after saving it in the .../BBEdit/Scripts folder;
otherwise just undo the work of the filter.
#!/usr/bin/perl
my $counter = 0; my $max = 5;
while (<>) { #read rows in succession
$counter++;
chomp; #remove linefeed
print "\t" if $counter == 4 && $max == 4; #skip a column
print; #add contents to column
if ($counter < $max) {
print "\t";
} else { #start a new row
print $/;
$counter = 0;
$max = 4; #allow for the missing tags data
}
}
#END
Let us know if there's any problem.
JD
--
This is the BBEdit Talk public discussion group. If you have a feature request
or need technical support, please email "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/bbedit/A1E07F6D-53F4-4581-B0EA-875478FDB47A%40gmail.com.
