Thanks all. I ended up using Jonas' regexp. Worked like a charm. :-) 
@Ouya, I was trying to add the hyphen to the numbers so that they are read correctly in excel without truncation.

On Tue, Oct 26, 2010 at 2:35 PM, solomon kariri <solomonkariri@gmail.com> wrote:
Yes,
Regex is the best choice

On Tue, Oct 26, 2010 at 12:00 PM, Dennis Kioko <dmbuvi@gmail.com> wrote:
I also support using regex
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke



--
Solomon Kariri,

Software Developer,
Cell: +254736 729 450
Skype: solomonkariri

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke



--

Thanks and Regards,
Erick Njenga Nyachwaya,
M: +254-725-008-790