Thank you Sam. I just tried this elegant solution. But with over 900 email it does not work. *I keep for small editions*.
Le lundi 13 mars 2017 19:40:34 UTC+1, Sam H. a écrit : > > 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] <javascript:>,nom1,prenom1,ville1 > > [email protected] <javascript:>,nom2,prenom2,ville2 > > [email protected] <javascript:>,nom3,prenom3,ville3 > > [email protected] <javascript:>,nom4,prenom4,ville4 > > [email protected] <javascript:>,nom5,prenom5,ville5 > > > > > > > > fichier2.csv > > > > [email protected] <javascript:> > > [email protected] <javascript:> > > > > > > > > result.csv > > > > [email protected] <javascript:>,nom1,prenom1,ville1 > > [email protected] <javascript:>,nom4,prenom4,ville4 > > [email protected] <javascript:>,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] <javascript:>" 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] <javascript:>. > > To post to this group, send email to [email protected] > <javascript:>. > > 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.
