Report Multiple Values from a text file

Content Authoring
1

(imported topic written by frankc91)

Hi all,

Is there a way to report on values from multiple lines of a text file on a Windows server?

Example would be:

Line 1 – error code: 500

Line 2 – error code: 600

Line 3 – error code: 700

Have property pull in only lines with “error code:” in the property (or at least results in

500

600

700

Then, we were looking to use the results to display in a web report.

Thoughts?

2

(imported comment written by BenKus)

Hey Frank,

Try this:

lines whose (it as lowercase contains “error code:”) of file “C:\blah.log”

Did you also want to only show the whole line (which is how I did it) or only the error code numbers? What if the same number occurs multiple times?

Ben

3

(imported comment written by frankc91)

Thanks Ben. Yes, I believe we wanted to just display the text/numbers to the right of the “error code:”. So could be a combination of #'s and words in each line.

Then, once we create a property that displays the results from each line (could be anywhere from 1 line to 6-7 pr so lines), then we wanted to display in a web report.

If you have any sample web report to display this data, that would be great too.

Something like this:

Hostname Error Codes

Server1 500 blah blah blah

Server2 600 blah blah blah

etc