Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-11-2012, 10:35 AM
sbatson5 sbatson5 is offline Help with replacing text with wildcards Windows 7 64bit Help with replacing text with wildcards Office 2007
Novice
Help with replacing text with wildcards
 
Join Date: Apr 2012
Posts: 1
sbatson5 is on a distinguished road
Default Help with replacing text with wildcards

I have a document with a long list of variables. I deleted all whitespace to push the characters together, and now I am trying to use wildcards to delete the characters I don't need.

For instance, I have:

Q5.14.begetablessuchaspumpkincarrotsyellow/orangesweetpotatoripemangoesorpapayaspassionfruiti lemabogakarotiviazivitamumaembemapapaiaumapesheni
Here, only Q5.14.b should stay. Things similar to this happen. So, I thought of using a wildcard in the Find and Replace dialogue. The wildcard is:



.b*
and is replaced with:
.b

I try this, but it doesn't delete the extra letter in the example above. What would the proper syntax be for 'delete all characters after a period and the letter b?'
Reply With Quote
  #2  
Old 04-12-2012, 01:19 AM
Charles Kenyon Charles Kenyon is offline Help with replacing text with wildcards Windows Vista Help with replacing text with wildcards Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,125
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

If your list of variables is concluded with a paragraph mark, try using:
.b*^13
.b^p

See Finding and Replacing Characters Using Wildcards
Reply With Quote
  #3  
Old 04-13-2012, 03:49 AM
macropod's Avatar
macropod macropod is offline Help with replacing text with wildcards Windows 7 64bit Help with replacing text with wildcards Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Assumin each line begins with Q and is followed by a number, period, 1-2 digit number, period, then a letter, you could use a wildcard Find/Replace, where:
Find = (Q[0-9].[0-9]{1,3}.?)*^13
Replace = \1^p
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
find and replace, wildcards



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with replacing text with wildcards Word 2010: Wildcards Replace tinfanide Word 2 09-10-2011 10:40 AM
Any wildcards search and replace in Powerpoint 2010? tinfanide PowerPoint 0 09-10-2011 02:17 AM
Help with replacing text with wildcards Word replacing problem!!!! Jamal NUMAN Word 2 07-08-2011 03:56 AM
Help with replacing text with wildcards Replacing default fonts mark98101 Word 1 01-31-2011 02:31 PM
Replacing / editting text LisaC Word 0 02-25-2010 03:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft