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

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

Basic wildcard use...I think

Postby wbullington » Wed Aug 09, 2006 11:31 pm

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: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Thu Aug 10, 2006 8:53 am

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

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

almost worked

Postby wbullington » Thu Aug 10, 2006 11:49 pm

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

Postby wbullington » Fri Aug 11, 2006 12:01 am

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: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Fri Aug 11, 2006 1:52 pm

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “WordPipe, ExcelPipe and PowerPointPipe Support”

Who is online

Users browsing this forum: No registered users and 1 guest