RobertJ has asked for the wisdom of the Perl Monks concerning the following question:
I have a small data base of the form
date TAB description TAB amount RETURN
The description can contain letters, numbers and various characters including . & - # etc
date is of format m/d/y and amount is of the format $dd.dd
I constructed the REGEX to strip out all but the amounts
[\t\/\d\w\ \-\#\*\&]*(\$[\d]*\.[\d]*)\rand then save in a column
\1\rto do this. It all works fine leaving only the amounts as a column. The problem occurs if there is a negative amount of the form -$dd.dd. I have been trying to use conditionals and alternations for about two hours with no luck. Would really like some enlightenment.
Thank you
I thought I posted this; however, can't see it. Excuse if I double posted.
For some reason I couldn't post this in Firefox, had to use Safari?
PROBLEM SOLVED
[\t\/\d\w\ \-\#\*\&]*\t(\-?)(\$[\d]*\.[\d]*)\r \1\2\r
Still can't figure out why I can't post with Firefox V9
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: REGEX Frustration
by GrandFather (Saint) on Dec 22, 2011 at 21:14 UTC | |
|
Re: REGEX Frustration
by ikegami (Patriarch) on Dec 22, 2011 at 20:49 UTC | |
|
Re: REGEX Frustration
by roboticus (Chancellor) on Dec 22, 2011 at 21:15 UTC | |
by GrandFather (Saint) on Dec 22, 2011 at 21:24 UTC | |
|
Re: REGEX Frustration
by mr.nick (Chaplain) on Dec 22, 2011 at 21:08 UTC | |
|
Re: REGEX Frustration
by JavaFan (Canon) on Dec 22, 2011 at 21:24 UTC | |
|
Re: REGEX Frustration
by TJPride (Pilgrim) on Dec 22, 2011 at 22:48 UTC |