[Solved] Find wildcard not working

[THEBookMan]

Have list of 1000+ in Writer like this:

BOOKMAN --- Jim@BookMan-Jim.Biz 1/10/17

Would like to replace "BOOKMAN --- " w/ ""

Tried "* --- ", "[alpha]+ --- ", "[:alpha:]+ --- " and ""[:Alpha:]+ --- ""(w/ double quotes)
all w/ "Regular Expressions" both on and off.

Would also like to del date (not in all entries)

Any suggestions are appreciated.
TNX
Jim [THE Book Man]

[FJCC]

These work for me

Code: Select all

[:alpha:]+ --- 
.+ --- 
^.+ --- 

with Regular Expressions turned on. Each has a trailing space to match the space between the last - and the J.

[THEBookMan]

Tried all 3 of those.

All returned "None Found"

(What are you talking about....There are 100's there, you *%*&^$@#@)

Anything else I should try? OO Settings, maybe?
Tnx

[RoryOF]

In Find and Replace window drop More Options and make sure "Regular expressions" is checked.

[FJCC]

Please post a small example document for which you have confirmed that your search fails. You can make this by copying a sample of text from your full document. To post a document, click Post Reply and then look for the Upload Attachment tab below the box where you type a response.

[THEBookMan]

Regular expressions is √ed

ANTHONY --- davidant1963@hotmail.com 2/6/2007
APPERSON --- whipple@apk.net
APPERSON --- Aubrey.Apperson@huntington.com
APPLEMAN --- marigolds27@yahoo.com
APRIL --- savanna_mccaslin@hotmail.com
ARCHABALD --- ladycoldfingers@yahoo.com
ARGENTO --- mickeygiroux@yahoo.com 01/29/08
ARMENTROUT --- jebest@flash.net

[RoryOF]

This lets us see the data, but we can'r see the internal structure of the document, which may be causing the problem.

[acknak]

I can't think why FJCC's suggestions might not work, but here's a slightly different attempt:

Search for: ^.*\s+\-\-\-\s+
Replace with: empty
Options/Regular expressions: ON

Click Replace All

Or, click "Find" to see what happens. If nothing matches, then I agree: we need to see a small sample document.

[THEBookMan]

^.*\s+\-\-\-\s+ Worked like a charm!

Thanks to all.
Jim [THE Book Man]

[THEBookMan]

SOLVED!