Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-30-2015, 12:55 AM
PRA007's Avatar
PRA007 PRA007 is offline Find what and copy that Windows 7 32bit Find what and copy that Office 2010 32bit
Competent Performer
Find what and copy that
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default

I made mistake in step 5.
I corrected it.

I actually want to find plain number after "US "
Initially I tried removing all commas But I didn't realize it will remove all commas from large doccument containing other text also.



Apology for changing the question.

Step 5 is making document again at original state.
Reply With Quote
  #2  
Old 10-30-2015, 01:05 AM
macropod's Avatar
macropod macropod is offline Find what and copy that Windows 7 64bit Find what and copy that Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Quote:
Originally Posted by PRA007 View Post
Step 5 is making document again at original state.
No, it doesn't, because it doesn't undo the RE insertions. If all you want after doing the data extraction is to restore the source document to its original state, why not just close it without saving?

As for the rest, try:
Code:
Sub Fees()
Application.ScreenUpdating = False
Dim StrOut As String, DocNew As Document
With ActiveDocument
  With .Range
    With .Find
      .ClearFormatting
      .Replacement.ClearFormatting
      .Forward = True
      .Wrap = wdFindContinue
      .Format = False
      .MatchWildcards = True
      .Text = "(US [3-9]),([0-9]{3}),([0-9]{3})"
      .Replacement.Text = "\1\2\3"
      .Execute Replace:=wdReplaceAll
      .Text = "(US )([0-9]{5} )"
      .Replacement.Text = "\1RE\2"
      .Execute Replace:=wdReplaceAll
      .Wrap = wdFindStop
      .Text = "US [R3-9][0-9E]{6}"
      .Replacement.Text = ""
      .Execute
    End With
    Do While .Find.Found
      StrOut = StrOut & Split(.Text, " ")(1) & vbCr
      .Collapse wdCollapseEnd
      .Find.Execute
    Loop
  End With
End With
Set DocNew = Documents.Add
With DocNew
  .Range.Text = StrOut
  .SaveAs2 FileName:="C:\Users\" & Environ("Username") & "\Desktop\i.txt", _
    FileFormat:=wdFormatText, AddToRecentFiles:=False
  .Close
End With
Set DocNew = Nothing
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-30-2015, 04:45 AM
PRA007's Avatar
PRA007 PRA007 is offline Find what and copy that Windows 7 32bit Find what and copy that Office 2010 32bit
Competent Performer
Find what and copy that
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default

Solved My all other problems with respect to find and replace as well as find copy and paste.

I have to do lot of find and replace and i record macro for that which some times exceeds line limits. Now i simply follow your above find and replace whic will save lot of lines.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find what and copy that Find specific rows then copy and paste to new doc konopca Word VBA 5 02-20-2014 02:34 PM
Find what and copy that Find Results in excel copy the rows to another sheet khalidfazeli Excel 2 02-06-2013 09:38 AM
Find what and copy that Find, copy and paste into a new page jperez84 Word VBA 24 09-20-2012 11:34 AM
Find what and copy that Macro that can find phrase and then find another and copy jperez84 Word VBA 10 09-19-2012 04:48 PM
Trying to find and copy all headings at the same time WaltR Word 7 08-21-2012 03:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:52 PM.


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