Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-15-2013, 10:11 AM
dexter30 dexter30 is offline Format text automatically Windows Vista Format text automatically Office 2003
Novice
Format text automatically
 
Join Date: Apr 2013
Posts: 20
dexter30 is on a distinguished road
Default

Wow! Now that worked!

Well maybe needs some fine tuning..

1) When there are 'Obs' and 'Justificativa' in the same paragraph, it only does the formatting for the first one. Then I would need to do find/replace again to format the second one. Is there a way to do it in only one step? (see attachaed files)

2) In the attached file PT_BEFORE, the code won´t work for the last 'Obs' (last line of the document). Can you see why?



Thanks!
Attached Files
File Type: doc PT_AFTER.DOC (20.5 KB, 10 views)
File Type: doc PT_BEFORE.DOC (20.5 KB, 12 views)
Reply With Quote
  #2  
Old 04-15-2013, 06:44 PM
macropod's Avatar
macropod macropod is offline Format text automatically Windows 7 64bit Format text automatically Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
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 dexter30 View Post
1) When there are 'Obs' and 'Justificativa' in the same paragraph, it only does the formatting for the first one. Then I would need to do find/replace again to format the second one. Is there a way to do it in only one step?
The simplest way of dealing with this is to simply click 'ReplaceAll' again. Finding either or both paragraphs can't be done in one pass - even with a macro, I'd do it in two passes.
Quote:
2) In the attached file PT_BEFORE, the code won´t work for the last 'Obs' (last line of the document). Can you see why?
Basically, it's an issue related to the length of the first paragraph. Try:
Find = (Nº [0-9]{1;8}/[!^13]@)[^13]{1;}([OJ][bu]s[.:ifcatv]{1;13})
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to find text in between two characters and then format selected text? qcom Word 5 02-19-2015 11:23 PM
automatically format meetings by me with some attendee wsw70 Outlook 0 06-24-2011 12:16 AM
Objective: Automatically export email text,attachment text to DB friendly format SilentLee Outlook 0 11-14-2010 02:45 PM
automatically extract footnotes into new file and apply character format to footnote hrdwa Word 0 02-27-2010 03:16 AM
format cells to automatically place quotes around text dirtleg Excel 1 09-16-2008 01:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:53 AM.


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