Extracting Selected Data from a txt file

[sidney786]

Hi All,

I am trying to extract selected data from a text file:

V 2010-08-18:15:37:00.686 GMT Daylight Time Time Zone: GMT + 1:00 - - PPES 1 7.4
G 2010-08-18:15:37:00.686 GMT Daylight Time Time Zone: GMT + 1:00 - - PPES FGN 1620
I 2010-08-18:15:37:00.686 GMT Daylight Time Time Zone: GMT + 1:00 - - PPES SRV cognos2:8010
I 2010-08-18:15:37:00.686 GMT Daylight Time Time Zone: GMT + 1:00 7zjZjneGw0WpmSUqCc_21136l7cgbvrh 104b PPRQ REQINFO PWQ,"/Cube 023 (Sector Sales and Margin)","D:/Business Reporting/Cubes/Live Cubes/Cube 023 (Sector Sales and Margin).mdc","",""
I 2010-08-18:15:37:01.218 GMT Daylight Time Time Zone: GMT + 1:00 7zjZjneGw0WpmSUqCc_21136l7cgbvrh 104b PPDS USR BMan
I want to extract the user, date and cube name from this file, does anyone know i can do this?

Thanks

Sid:

[opaper]

How will you be extracting the data from the file? Using VB or something else? If you want it with the help of VBA then simply create a code which looks like this:

Option Explicit
Public iR, jZ As Long, theRows
Sub getFields()
    theRows = Application.CountA(ActiveSheet.Range("A:A"))
    For jZ = 2 To theRows
        Open Cells(jZ, 6) For Input Access Read As #6 
            Line Input #6, xR  
                If Left(iR, 7) = "Title: " Then
                    Cells(jZ, 2) = Right(iR, Len(iR) - 7)
                End If
                If Left(iR, 8) = "Author: " Then
                    Cells(jZ, 4) = Right(iR, Len(iR) - 8)
                End If
                If Left(iR, 9) = "Subject: " Then
                    Cells(jZ, 3) = Right(iR, Len(iR) - 9)
                End If
        Loop
        Close #6  
    Next    
End Sub

[sidney786]

Hi,

Thanks for your reply, but the code you have supplied is to work with an excel worksheet?

Sid

[Acalapati]

To read a text file, look at the class java.io.BufferedReader with the method readLine ( ) . Then to parse your input file , it depends on how the data are structured : csv , fixed length data. xls file for output, there are libraries that enable the create ( POI jakarta amongst others).