reg help

dabombst · Post by **dabombst** » Mon Sep 25, 2006 9:59 pm

Hi

I only need the data btween the ",".

EC06919B0150355,EC06919B0150420,066
EC06919B0151231,EC06919B0151601.1,372
EC06919B0151602,EC06919B0151602,001
EC000301523,EC000301641,119
ECg004021003,ECg004028702,7700

should be
EC06919B0150420
EC06919B0151601.1
EC06919B0151602
EC000301641
ECg004028702

Thanks

Bob Hansen · Post by **Bob Hansen** » Mon Sep 25, 2006 11:10 pm

Search for: ^.*,(.*),.*
Replace with: \1

Make sure check is in box for Regular expressions in Search/Replace box.
Configure/Preferences/Editor POSIX is recommended, but not needed here.

ben_josephs · Post by **ben_josephs** » Tue Sep 26, 2006 7:51 am

Posix syntax is required for this regular expression, as it uses parentheses in the Posix style.

dabombst · Post by **dabombst** » Tue Sep 26, 2006 4:37 pm

you guy are great.

Bob Hansen · Post by **Bob Hansen** » Tue Sep 26, 2006 9:19 pm

Thanks Ben, I missed that, too obvious .... aargh!

Community

reg help

reg help

Thanks!!!