I have a single field that contains a lot of text (its an output log from a computer system)

I want to set up a database that has several tables:

1 - output log (single field)

2 - table of lookup values (the actual text to count up in the log, and the part number that output refers to)

3 - Final list of part numbers and count of them

I want to do a loop for the table of lookup values - starting at the top - look for the specified text in the output log, and count up the number of times that text occurs in the log, if not move on to next part number

how would i do this?

Edited May 12, 200619 yr by Guest

The PatternCount function will tell you how many times a given string appears in another.

What I'd try is to create a calculation field in your lookup table:

_c_TermCount (number)

PatternCount(Log::LogText; LookUpTerm)

[Log is your logfile name; LogText is the field with the log text in it; LookUpTerm is the field in the lookup table that has the term in it]

Now, place _c_TermCount and LookUpTerm on a list layout for the Lookup table. It should give you a summary of your lookup terms and their counts.

HTH,

David