Hi, a total newbie to this. I was wondering if there is a way to extract certain lines which contain certain strings from a specific column in a csv file? What I mean is, for instance, if there is a csv file of the following:
Canada,USA,France,Italy,Germany,Japan Apple,Orange,Strawberry,Banana,Pear,Mango One,Two,Three,Four,Five,Six Banana,Orange,Apple,Strawberry,Mango,Pear Blue,Yellow,Green,Red,Purple,Pink Uno,Dos,Tres,Cuatro,Cinco,Seis Red,Yellow,Pink,Purple,Green,Blue I would want to extract the entire line which contains the string, "Strawberry" and "Green" on the third column. The result would be: Apple,Orange,Strawberry,Banana,Pear,Mango Blue,Yellow,Green,Red,Purple,Pink Is there a way of using regex? Thanks. -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting to the group. 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/90e70997-e01a-4f2d-8bd6-f8c374f77eca%40googlegroups.com.
