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:


Here's what I want to end up with:


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


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

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

Replace with



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