Replace text with regular expressions in a text editor

Question

I need to edit lines in a text file.

The text files contains more than 100 lines of data in the below format.

 Cosmos Rh Us (Paperback)   $10.99   Shipped: 
 The Good Earth (Paperback) $6.66    Shipped: 
 BEST OF D.H. LAWRENCE (Paperback) $7.89 Shipped:
 ...

These are excerpts from the online book shop I use to buy books

I have this data in a test editor. How do I edit it [Fine/Replace] such that the data becomes like this

  $10.99
  $6.66
  $7.89

or better, without the dollar sign, since it'll be easy total it.

I use notepad++ as text editor.

score 2 · Answer 1 · answered Nov 16 '12 at 12:15

2

Search for (don't forget to enable regular expressions in the replace box!)

^.*\$(\d+\.\d+).*$

and replace all with

\1

answered Nov 16 '12 at 12:15

Tim Pietzcker

328,213
58
503
561

user said it would be better without the dollar sign – garyh Nov 16 '12 at 12:18
@garyh: Yes, the dollar sign will be removed as requested. – Tim Pietzcker Nov 16 '12 at 13:39

score 1 · Answer 2 · answered Nov 16 '12 at 12:18

You could simply match full lines and capture all numbers after the $ sign:

Find what: ^[^$]*\$(\d+\.\d+).*$
Replace with: $1

Make sure that you don't check the ". matches newline" option. And note that this will behave unexpectedly if you have multiple $ signs in a line.

You might need to update to Notepad++ 6. Before that some regex features were not working properly.

score 0 · Answer 3 · answered Nov 16 '12 at 12:17

0

Find:

((?<=\$)[\d\.]+)

Replace With:

\1 or $1 (whichever Notepad++ uses)

answered Nov 16 '12 at 12:17

garyh

2,782
1
26
28

That is effectively a NOP because you write back what you have matched. – Martin Ender Nov 16 '12 at 12:19
Ah, I'm with you now. I've just matched the actual text rather than the whole line to replace with the capture. Ignore me. – garyh Nov 16 '12 at 12:31
"no operation" what I was trying to say is, that your answer will leave any possible input unchanged. – Martin Ender Nov 16 '12 at 12:32
Yep. Me trying to be clever :) – garyh Nov 16 '12 at 12:34

score 0 · Answer 4 · answered Nov 16 '12 at 12:27

0

first regex will be replaced with nothing

[a-zA-Z0-9].*\)

second regex will be replaced with nothing

[a-zA-Z]+\:

answered Nov 16 '12 at 12:27

Saddam Abu Ghaida

6,381
2
22
29

Replace text with regular expressions in a text editor

4 Answers4