Page 1 of 1

moving a symbol

Posted: Tue Jun 19, 2007 11:52 pm
by Mikeyboyeee
I'm working with some figures that come in with the negative indicator after the digits and I need to move it to the start of the digits

Here's what I'm starting with:

123.45-
1.14-
0.25-

Here's what I want to end up with:

-123.45
-1.14
-0.25

I haven't had any luck so far - I figure it's got to be a simple fix... any ideas??

Thanks

Posted: Wed Jun 20, 2007 8:32 am
by DataMystic Support
Use the EasyPattern

[ capture(1+ digits or '.'), '-' ]

Replace with

-$1

THANKS!!!

Posted: Wed Jun 20, 2007 10:39 pm
by Mikeyboyeee
Thank you -- brilliant! works like a charm