If fichier2.csv is relatively small, you can convert it into a regular expression, and then use "process lines containing" to remove lines from fichier1.csv that match it.

The regular expression would look like:

^(email2@site\.com|email3@site\.com),

You can achieve this with the following find/replace operations in fichier2.csv (with "Grep" turned off):

.    =>   \.

\r   =>   |

Then wrap the resulting string up in ^( and ),

Turn on "Grep" and "Delete matched lines" in the Process Lines Containing dialog.

I don't know what BBEdit's maximum regex length is, but I've been able to do similar with fairly long expressions

On 13 Mar 2017, at 1:26 PM EDT, Magick! wrote:

 Hello,

I have two text files: fichier1.csv and fichier2.csv and I want to remove from the first all the lines that contain an email address of the second.
How to make it with BBEdit?
THX

--

Bonjour,

J'ai deux fichiers textes : abonnes.csv et desabonnes.csv et je souhaite supprimer du premier toutes les lignes qui contienne une adresse email du
second.
Comment le réaliser simplement avec BBEdit ?

fichier1.csv

[email protected],nom1,prenom1,ville1
[email protected],nom2,prenom2,ville2
[email protected],nom3,prenom3,ville3
[email protected],nom4,prenom4,ville4
[email protected],nom5,prenom5,ville5



fichier2.csv

[email protected]
[email protected]



result.csv

[email protected],nom1,prenom1,ville1
[email protected],nom4,prenom4,ville4
[email protected],nom5,prenom5,ville5



--
This is the BBEdit Talk public discussion group. If you have a
feature request or would like to report a problem, please email
"[email protected]" rather than posting to the group.
Follow @bbedit on Twitter: <http://www.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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/bbedit.

--
This is the BBEdit Talk public discussion group. If you have a feature request or would like to report a problem, please email
"[email protected]" rather than posting to the group.
Follow @bbedit on Twitter: <http://www.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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/bbedit.

Reply via email to