Community

Posted: **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

Posted: **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.

Posted: **Tue Sep 26, 2006 7:51 am**

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

Posted: **Tue Sep 26, 2006 4:37 pm**

you guy are great.

Posted: **Tue Sep 26, 2006 9:19 pm**

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

Community

reg help

reg help

Thanks!!!