UNIX Numbers

swilsher · Post by **swilsher** » Sat Jan 28, 2006 4:50 pm

I often use textpad to copy column data from UNIX reports and paste into Excel. Is there a way to convert the negative sign in the back of the number as UNIX does to the front as Excel understands it. Example: 6.23- would become -6.23.

Steve

Ed · Post by Ed » Sat Jan 28, 2006 5:45 pm

Replace
([0-9.]+)-
with
-\1

Regular expressions checked
Posix Regular expression

swilsher · Post by **swilsher** » Sun Jan 29, 2006 12:54 am

I'm not sure I understand. I tried what you said, but it comes back with, "Cannot find literal string"

talleyrand · Post by **talleyrand** » Sun Jan 29, 2006 4:13 am

There is a box on the search and replace dialogue that says Regular Expression. Check it.

Before you do that though, go into Configure, Preferences -> Editor and check the last box. It mentions POSIX.

swilsher · Post by **swilsher** » Mon Jan 30, 2006 11:48 pm

Got it. Thanks