raw text to columns...

[ashishgaj]

hi! buddies...
i m working on reports in my office....
i got a situation.....here...very tough...

i daily generate tons of reports from a database server...and my boss asks to convert it into tabular form....hectic job i do...:mad:
i get the file as.

::our company name::
ADDRESS LINE1
ADDRESS LINE2

DATE:XX-XX-XXXX PLACE: CITY NAME

TITLE OF OUR BANK
SELF HELP GROUPS BANK STATEMENTS
BRANCH :: 1457
-----------------------------------------------------------------------
SNo. Acct ID NAME CUSTID AMOUNT BALANCE date
-----------------------------------------------------------------------
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08

-pagebreak-

::our company name::
ADDRESS LINE1
ADDRESS LINE2

DATE:XX-XX-XXXX PLACE: CITY NAME

TITLE OF OUR BANK
SELF HELP GROUPS BANK STATEMENTS
BRANCH :: 1457

-----------------------------------------------------------------------
SNo. Acct ID NAME CUSTID AMOUNT BALANCE date
-----------------------------------------------------------------------
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08

::our company name::
ADDRESS LINE1
ADDRESS LINE2

DATE:XX-XX-XXXX PLACE: CITY NAME

TITLE OF OUR BANK
SELF HELP GROUPS BANK STATEMENTS
BRANCH :: 1457

-----------------------------------------------------------------------
SNo. Acct ID NAME CUSTID AMOUNT BALANCE date
-----------------------------------------------------------------------
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
1. 002231056774836 rajni 987678 10,88,89.00 190,89.00 20-07-08
.
.
END OF THE REPORT
like this there will be any number of 'rows' in the report basing on the data date...old date means more data....more cut paste...

the thing is i only want the 'columns' data from the report...and convert it into excel file.....
sad thing i do not know some programmin....and i have to do it mannualy...copying and pasting which takes a lot of serious time...over it....can any body help me...can a program in java do that for me....:):confused: i wud be too gr8ful...

[Fubarable]

This is not a site for getting others to do your work for you. If you want to learn Java and then learn to do this yourself, we'll be more than happy to help. Otherwise you're better off going to rent a coder . com.