Input Formats

Re: Break string

hg363 — Fri, 10 Jul 2009 22:03:13 GMT

Hi look thank you very much indeed for taking the time to show me. May I please ask more question as I very new to LP, how would one pass the TEXTLINE found by LP to this script. So weather I use this method

objLogParser.ExecuteBatch strQuery, objInputFormat, objOutputFormat

or this method

objShell.run ("LogParser " & string_is)

how when LP finds that data I am looking for do I then get LP to pass it to the script, please will you kindly show me kind regards HG UK

Re: Break string

kateroh — Fri, 10 Jul 2009 21:25:32 GMT

Oh, sorry, it was C#. Here is VB:

Dim reader As StringReader = New StringReader(logText)
Dim line As String = reader.ReadLine()

While (line Is Not Nothing)
    Dim linePieces() As String = line.Split(Microsoft.VisualBasic.ChrW(32))
    line = reader.ReadLine()

End While

Re: Break string

hg363 — Fri, 10 Jul 2009 08:13:46 GMT

Hi thank you very much for your prompt answer but I suspect the answer you have provided is resolving my problem using some form of programming language. Can this be achieved directly by Log Parser or vbscript? Thank you Mr Ghelani

Re: Break string

kateroh — Fri, 10 Jul 2009 07:50:49 GMT

using (StringReader reader = new StringReader(logText))
{
   string line;
   // read line by line
   while ((line = reader.ReadLine()) != null)
   {
        // split each line into pieces
        string[] linePieces = line.Split(' ');
   }
}

Break string

hg363 — Thu, 09 Jul 2009 19:46:01 GMT

Hi to all forum members. Can some one please assist me. I am using LP to interrogate a text file and pull out TEXTLINE data. Here is an example

204 00:13:21:5f:04:d4 learned 0 bridging 1/9

Is there any clever way of telling LP that when it finds this data to break it down like this

204

00:13:21:5f:04:d4

learned

bridging

1/9

and if there is please can some one give me an example and demonstrate how this can be done, need this last bit to complete a project. Regards hg363 UK