View Single Post
  #3   Report Post  
Jezebel
 
Posts: n/a
Default Find and Replace: delete a line & find a number 10

#1. With 'Use wildcards' checked, search for [a-z]@: 1^013 and replace with
nothing

#2. This is trickier. Bear in mind that you are matching strings of digits,
not numbers as such. You could use: [2-9][0-9] for 20 to 99, then
[1-9][0-9]{2,} for 100 onwards. Can't answer about your number ranges
without knowing what they look like.


An alternative approach is to put your list into Excel, using ": " as the
column delimiter. Then it's easy to sort on the number and delete (or
whatever) the rows you don't want. Come to think of it, you could do that in
Word also: replace ": " with tab, then select all and convert text to table,
then sort on column 2.





"Janis Anna" Janis wrote in message
...
TWO THINGS

#1 - I have a list that looks like the list below....

able: 1
about: 18
above: 1
accompany: 1
across: 3
actually: 2
adoring: 1

I want Find and Replace to automatically delete each line that equals ":
1"... (i.e.: delete the lines "able: 1" and "above: 1" and "adoring: 1")
the
whole line... I cannot seem to get past this - (a): 1


#2 - I want Find any number over 20 (i.e.: 20) Or a range of numbers
(i.e.:
20 & 40)


Can anyone help?