Basic wildcard use...I think

Discuss WordPipe, ExcelPipe and PowerPointPipe. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
wbullington
Posts: 3
Joined: Wed Aug 09, 2006 1:04 am
Location: Texas

Basic wildcard use...I think

Post by wbullington »

I am trying to remove the following lines of text and am unable to completely remove with one statement:

11. (tab)Label (tab)FR05
(tab)600-118570(tab) LABEL BOX END CP 4 X 5 YLW
(tab)FR79
(tab)600-113168(tab) LABEL 6 X 3 BOX END YLW (113U)

Keep in mind that this is an auto numbered section... Thanks in advance for any help.
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

See the help file under ‘Replacing using wildcards’.

I'm not sure if you can use the '11' or not, but try this wildcard pattern:

Label*(113U)

Replace with nothing.
wbullington
Posts: 3
Joined: Wed Aug 09, 2006 1:04 am
Location: Texas

almost worked

Post by wbullington »

Simon,
That string almost worked...but it left the final parenthesis ")"....I think it saw it as a wildcard. Any suggestions.

Also, it did remove the 11 and renumber everything below properly.

I see in the Help where it says:
"Any string of characters * s*d finds "sad" and "started". "

I suspect this is what you were talking about. I think it may be something to consider to add some information to the Help that talks about full lines of text...example: using the "*" wildcard in a sentence or paragraph between the first and last word will remove every thing between the two words and the words themselves.
wbullington
Posts: 3
Joined: Wed Aug 09, 2006 1:04 am
Location: Texas

Got it to work...but still have a question

Post by wbullington »

Simon,
Ok, I used the following 2 strings and it worked:
1. Label*(113U) Wildcards on
2. )^p Normal
My question is why did the 1st string not get the close paren?

Thanks,
Wayne
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

Try escaping the ( by preceding it with \ e.g.

\(

Microsoft Word wildcards are very non-standard, but it does seem they use the (..) for grouping, although this is not documented properly.
Post Reply