![]() |
#1
|
|||
|
|||
![]() ![]() 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 |
#2
|
||||
|
||||
![]()
Are those asterisks literal asterisks, or just a representation of variable content?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
They are really asterisks, the file is like that.
Data elements are separated by asterisks (delimiters). It's an EDI file. Thanks again |
#4
|
||||
|
||||
![]()
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] |
#5
|
|||
|
|||
![]()
Thanks a lot.
It worked like magic. |
![]() |
|
![]() |
||||
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 |
![]() |
Jamal NUMAN | Word | 3 | 06-28-2011 12:34 AM |
Suggestion required | domex | Word | 0 | 10-06-2010 05:35 AM |