Results 1 to 2 of 2
  1. #1
    ashishgaj is offline Member
    Join Date
    Jan 2011
    Posts
    1
    Rep Power
    0

    Smile raw text to columns...

    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...

  2. #2
    Fubarable's Avatar
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Posts
    19,315
    Blog Entries
    1
    Rep Power
    26

    Default

    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.

Similar Threads

  1. how to add columns from Matrices(2D array)
    By John_shok in forum New To Java
    Replies: 7
    Last Post: 10-04-2010, 05:33 PM
  2. Jlist Columns
    By DenRed in forum New To Java
    Replies: 2
    Last Post: 10-02-2009, 10:33 AM
  3. Using Columns With JTextField
    By The Evil Genius in forum AWT / Swing
    Replies: 1
    Last Post: 03-17-2008, 02:01 AM
  4. Problems with JSF (columns)
    By Peter in forum JavaServer Faces (JSF)
    Replies: 2
    Last Post: 07-04-2007, 07:43 AM
  5. sort columns in jtable
    By Alan in forum AWT / Swing
    Replies: 2
    Last Post: 05-14-2007, 06:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •