Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2016, 12:00 PM
psychson psychson is offline Wildcard suggestion please! Windows XP Wildcard suggestion please! Office 2013
Novice
Wildcard suggestion please!
 
Join Date: May 2016
Posts: 3
psychson is on a distinguished road
Default Wildcard suggestion please!


I need help an google search did not help me much.
I mixed wildcards and I could not make much sense and found nothing .


I have a huge file with too much information and I need to look over 500 pages to search for only 12 lines.
I need to look at this string of info:
CLM*1234*0.0***77:A:4*Y**N*N*********N
But this string of info is in each single page, it repeats over a thousand times. All I need is to get 12 of those line where the *0.0*** is not in it and it must be a dollar amount there instead of *0.0***.
For the most part it will have *0.0***, but around 12 will have something like *250.00*** ou *580.00***
I can't find a way to use a wildcard to search for only those 12 lines with an amount other than *0.0***
Any suggestions ?
Thanks a lot
Reply With Quote
  #2  
Old 05-26-2016, 06:28 PM
macropod's Avatar
macropod macropod is offline Wildcard suggestion please! Windows 7 64bit Wildcard suggestion please! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
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

Are those asterisks literal asterisks, or just a representation of variable content?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-27-2016, 08:11 AM
psychson psychson is offline Wildcard suggestion please! Windows XP Wildcard suggestion please! Office 2013
Novice
Wildcard suggestion please!
 
Join Date: May 2016
Posts: 3
psychson is on a distinguished road
Default

They are really asterisks, the file is like that.
Data elements are separated by asterisks (delimiters).
It's an EDI file.

Thanks again
Reply With Quote
  #4  
Old 05-27-2016, 03:17 PM
macropod's Avatar
macropod macropod is offline Wildcard suggestion please! Windows 7 64bit Wildcard suggestion please! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
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

In that case you could use a wildcard Find like:
Find = CLM\*[0-9]{4}\*[1-9][!^13^l]{1,}
That will find any paragraph or line beginning with CLM* following by a 4-digit number, then * following by a number other than 0.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-27-2016, 03:27 PM
psychson psychson is offline Wildcard suggestion please! Windows XP Wildcard suggestion please! Office 2013
Novice
Wildcard suggestion please!
 
Join Date: May 2016
Posts: 3
psychson is on a distinguished road
Default

Thanks a lot.
It worked like magic.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change characters outside a wildcard while keeping wildcard results nymusicman Word VBA 2 04-10-2014 08:17 AM
Suggestion for powerpoint presentation on sofware products jamesdann PowerPoint 0 01-08-2014 02:57 AM
Spelling check - No suggestion Patictor Word 0 10-11-2011 12:24 AM
Wildcard suggestion please! Suggestion: Scroll bar of the Style should automatically to show the name of the styl Jamal NUMAN Word 3 06-28-2011 12:34 AM
Suggestion required domex Word 0 10-06-2010 05:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:50 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