BBEdit Grep: Find column of data in CSV
169 views
Skip to first unread message
Pindar Creative
Jun 20, 2023, 12:13:13 PM6/20/23
to BBEdit Talk
Hi, pushing my grep skills to the limit. I need to find everything in the fourth column from the data/csv file below. Text in fourth column could be anything. Any help is greatly appreciated, thanks
"First Name","12","third","fourth","fifth","sixth","etc"
"First Name","20","third","fourth","fifth","sixth","etc"
"First Name","16","third","fourth","fifth","sixth","etc"
"First Name","32","third","fourth","fifth","sixth","etc"
"First Name","34","third","fourth","fifth","sixth","etc"
"First Name","18","third","fourth","fifth","sixth","etc"
"First Name","6","third","fourth","fifth","sixth","etc"
"First Name","10","third","fourth","fifth","sixth","etc"
"First Name","4","third","fourth","fifth","sixth","etc"
"First Name","29","third","fourth","fifth","sixth","etc"
"First Name","30","third","fourth","fifth","sixth","etc"
"First Name","39","third","fourth","fifth","sixth","etc"
"First Name","12","third","fourth","fifth","sixth","etc"
"First Name","11","third","fourth","fifth","sixth","etc"
"First Name","37","third","fourth","fifth","sixth","etc"
"First Name","3","third","fourth","fifth","sixth","etc"
"First Name","56","third","fourth","fifth","sixth","etc"
"First Name","3","third","fourth","fifth","sixth","etc"
"First Name","55","third","fourth","fifth","sixth","etc"
"First Name","7","third","fourth","fifth","sixth","etc"
"First Name","20","third","fourth","fifth","sixth","etc"
"First Name","16","third","fourth","fifth","sixth","etc"
"First Name","32","third","fourth","fifth","sixth","etc"
"First Name","34","third","fourth","fifth","sixth","etc"
"First Name","18","third","fourth","fifth","sixth","etc"
"First Name","6","third","fourth","fifth","sixth","etc"
"First Name","10","third","fourth","fifth","sixth","etc"
"First Name","4","third","fourth","fifth","sixth","etc"
"First Name","29","third","fourth","fifth","sixth","etc"
"First Name","30","third","fourth","fifth","sixth","etc"
"First Name","39","third","fourth","fifth","sixth","etc"
"First Name","12","third","fourth","fifth","sixth","etc"
"First Name","11","third","fourth","fifth","sixth","etc"
"First Name","37","third","fourth","fifth","sixth","etc"
"First Name","3","third","fourth","fifth","sixth","etc"
"First Name","56","third","fourth","fifth","sixth","etc"
"First Name","3","third","fourth","fifth","sixth","etc"
"First Name","55","third","fourth","fifth","sixth","etc"
"First Name","7","third","fourth","fifth","sixth","etc"
Rich Siegel
Jun 20, 2023, 12:14:37 PM6/20/23
to BBEdit Talk
If the file is well-formed CSV and the language setting is "Comma-Separated Values" (or the file's name ends in ".csv"), you can use the "Columns" submenu on the Edit menu to do things. This includes putting the insertion point in the fourth column and selecting "Copy Column".
Enjoy,
R.
--
This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "sup...@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+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/d301b954-76ec-46c8-bb0f-c9674d761aacn%40googlegroups.com.
Pindar Creative
Jun 22, 2023, 10:51:52 AM6/22/23
to BBEdit Talk
Wow, learn something every day! 25+ years using BBEdit and it is still my go-to app - such a powerful tool! Thank you Rich
Reply all
Reply to author
Forward
0 new messages