Pick Keywords

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Wonder if someone can help me please. I have a database containing a heck
of a lot of info. One particular area of information shows errors found in
files. The problem is that the the error shows not only a specific error
number but a lot of useless text as well.

Does anyone know of a way to pick the error code only out of the text string
so I can report and show a 'Count' of each of the error numbers.

Many thanks

Chris
 
First you would need to tell us what distingushes the error code from the
rest of the string - preceeded by "ERROR #" or some such. Or maybe followed
by a dash.

Is the code allways the same lenght?

If you have answers to the above then you can use the Mid function.
 
Back
Top