Advice on parsing flat test files for certain strings

From: Neil Owens (neil_o_at__NOSPAM_ntlworld.com)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 23:08:48 GMT

I manage about 100 servers and each server produces a flat text file
containing certain useful lines of text amongst may lines of dross from a
bespoke application. I can import this flat text file into a table(table1).
I could also produce another table containing text strings and an ID field
to save duplicate data in Table1.

My question is that I need to parse each entry from each server to see if a
line of text contains a number of words/strings and then act on this. I've
used triggers with much success on other types of data (e.g. Windows Event
Logs) and would like to use an input trigger here. But I don't have a clear
idea on the best way to do this and would like some hints on how to do this
with a string match .

Is it best to store all possible search strings in another table( a 'rule'
table?) and try a join (but what if I needed just a word from a whole
string - sort of a VBScript 'Instr(....)?) or is there some other masterful
way of doing this?

Any hints appreciated

TIA

Neil

Relevant Pages

  • Re: Learning intervals across the strings
    ... Remember, scales can be played on single strings, adjacent ... to the octave. ... So for example if one fingers b flat on the sixth string fifth ... b flat to c equals a major second, b flat to d flat equals ...
    (rec.music.classical.guitar)
  • Re: Learning intervals across the strings
    ... Remember, scales can be played on single strings, adjacent ... to the octave. ... So for example if one fingers b flat on the sixth string fifth ... b flat to c equals a major second, b flat to d flat equals ...
    (rec.music.classical.guitar)
  • Re: Bass string preferences?
    ... but I can always do it again with a new gauge. ... The old "the bass came with strings that sounded great but I ... These are wound on the outside with flat metal tape rather than round ... because the tape of flat wounds is usually wider than that winding on ...
    (alt.guitar.bass)
  • Re: "Flat Top" strings or half-round... who makes em?
    ... flat wound strings just sound dead. ... tried grinding them flat or smashing them flat after the round wraps are ... Thanks for the tip on the John Pearse variant. ...
    (rec.music.makers.guitar.acoustic)
  • Re: Bass string preferences?
    ... but I can always do it again with a new gauge. ... The old "the bass came with strings that sounded great but I ... These are wound on the outside with flat metal tape rather than round ...
    (alt.guitar.bass)