Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Text find-replace
#1
Hallo Friends.

I just bought QuickMacros but I'm absolutely unable to write any code...and so I would like your precious help for two probably quiet simple macros that one day may be helpful also to others...


With the Date Ordering macro I got from Gintiras, the new data came out nicely as in the exemple below:


(Sat) 20- 1-1900 21:38 Saturn (Sag) 165° (Gem) Pluto


(Sun) 18- 2-1900 20:56 Saturn (Cap) 162° (Gem) Pluto


(Wed) 23- 5-1900 20:59 Saturn (Cap) 162° (Gem) Pluto


(Mon) 25- 6-1900 18:59 Saturn (Cap) 165° (Gem) Pluto


Anyway, I would like to reduce by half (=0.5cm instead of 1cm) the space between the lines because as they are they occupy too much space. I try to do it with Words but cannot do it through it because the line space function cuts the lines instead of formatting them properly. This due to the fact that the minimum possibility it gives me is 1cm and not less...

The second macro I would need is a macro that will check all the data in the document and eliminate doubles (or repeated) data.

Thank You very much for your kind cooperation.

Best Regards.

Silvano Tironi
#2
That macro doesn't insert any empty lines. Try to run it again, but in another editor, eg notepad or wordpad.
____________________________________

To cut repeated lines, use QM's find-replace dialog.
Trigger Ctrl+Shift+Alt+H.

In "From" field, use

(?m)(^.+\r\n)((?s).+?)?\1

In "To" field, use

$1$2

Uncheck "Match case", "Whole word". Check "Regexp". Repeatedly click "Replace All", until third button shows 0. If doubled lines are adjacent, then you will have to click only several times, else it can take many time.


Attached Files Image(s)
   
#3
Excellent Gintaras !

Many Thanks and have a Good Day.

Best Regards.

Silvano Tironi


Forum Jump:


Users browsing this thread: 1 Guest(s)