moving a symbol

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
Mikeyboyeee
Posts: 3
Joined: Tue Jun 19, 2007 11:48 pm

moving a symbol

Post 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
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

Use the EasyPattern

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

Replace with

-$1
Mikeyboyeee
Posts: 3
Joined: Tue Jun 19, 2007 11:48 pm

THANKS!!!

Post by Mikeyboyeee »

Thank you -- brilliant! works like a charm
Post Reply