Thread: [Solved] Wildcard suggestion please!
View Single Post
 
Old 05-26-2016, 12:00 PM
psychson psychson is offline Windows XP Office 2013
Novice
 
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