File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes Regarding Tabular Data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Regarding Tabular Data" Watch "Regarding Tabular Data" New topic

Regarding Tabular Data

praveen valaboju

Joined: Mar 28, 2008
Posts: 5
I am Having a Table data in this format

Name Date Invoice
Mark 11-11-2007 58986985

Amount WorkOrderNumber
50000 589696

can any help me regarding extracting the data for Name,Date,Invoice,Amount,WorkOrderNumber

Output Should be

Name Mark

Date 11-11-2007

Invoice 58986985

Amount 50000

WorkOrderNumber 589696

I have tried in this manner but unable to succeed

Matcher m = Pattern.compile("Name(\\s*\\W*\\w*\\W*.
W+([0-9-]+)|Invoice (\\W*(\\d+))|Amount(\\W*(\\d+))|WorkOrderNumber([\\d]*,*)").matcher(line1);

Any suggestions are welcome.


V.Praveen :roll:
I agree. Here's the link:
subject: Regarding Tabular Data
It's not a secret anymore!