Hi All,
I have file looks like this:
ID	Lname	Fname	Code1	Group1	Detail1	..	Code11	Group11	Detail11
12345678,	Kevin,	Thomas	FTR	Groupv	GT-HYTRERNOT	..	MOL	GroupC	BN-JUYTRREEWWW
.......									
135434432	Laura	Xii	ZAS	CDER	CV-JHYTREWW	…..	ADSCVT	XCERE	YY-DERWQQQQ
135434433	Kevin,	Xii	VVV	CDER	VV-JHYTREWW	…..	ADSCVT	XCERE	YY-DERWQQQQ

search only if the first two char in Detail..N = (BN,VV) starting the right most column..If found exit

Final result will look like:

ID	Lname	Fname	code	group	detail
12345678,	Kevin,	Thomas	MOL	GroupC	BN-JUYTRREEWWW
135434433	Kevin,	Xii	VVV	CDER	VV-JHYTREWW
Thanks in advanve
Kevin