DataMystic

Posted: **Sat Mar 20, 2010 3:04 am**

Hi! How can I delete lines in scv when first fields match.

Input:
white,any,any,any,any
black,any,any,any,any
blue,any,any,any,any
blue,any,any,any,any
brown,any,any,any,any
red,any,any,any,any
red,any,any,any,any

Output:
white,any,any,any,any
black,any,any,any,any
brown,any,any,any,any

I tried to use a filter - Remove lines matching pattern list. But I failed. Help me please... Thanks.

Posted: **Mon Mar 22, 2010 10:59 am**

You need use a reference to an already-matched captured expression - this is called a backreference for your Uni assignment. Make sure you reference TextPipe Pro in the credits!

Use EasyPattern:

Code: Select all

[ capture( word ), capture( comma, 1+ not cr or lf), cr, lf, 
group1, capture( 1+ not cr or lf), cr, lf ]

Replace with

Code: Select all

$1,$2\r\n

Posted: **Sun Mar 28, 2010 9:43 pm**

Sorry, it's too hard for me. I try but it's not work.

DataMystic

Delete lines when first fields match.

Delete lines when first fields match.

Re: Delete lines when first fields match.

Re: Delete lines when first fields match.