View Single Post
  #1 (permalink)  
Old 05-09-2008, 01:22 PM
jazz2k8's Avatar
jazz2k8 jazz2k8 is offline
Member
 
Join Date: Apr 2008
Posts: 94
jazz2k8 is on a distinguished road
[SOLVED] How to achieve this?
i am having data like this:Input say it as a.txt

S.No Description Qty. Units Rate (Rs.) Value (Rs.)
1 Aviation Lamp 1 Nos 3700 3,700
2 Lighting Arrester 1 Nos 1600 1,600
3 Aviataion Lamp Cable 31 Rmt 270 8,370

Gross Total 13,670
The above Total include Services Tax Amount of Rs 536
Total Invoice Value 13,670

i would like to get this data in the form of:Output should be

S.No 1
Description Aviation Lamp
Qty. 1
Units Nos
Rate (Rs.) 3700
Value (Rs.) 3700

S.No 2
Description Lighting Arrester
Qty.1
Units Nos
Rate (Rs.) 1600
Value (Rs.) 1600

S.No 3
Description Aviataion Lamp Cable
Qty.31
Units Nos Rmt
Rate (Rs.) 270
Value (Rs.) 8,370

Gross Total 13,670
Tax Amount of Rs 536
Total Invoice Value 13,670

--------------------------------

I tried with Buffered Reader, String Buffer used some regex code.but i am unable to get this..can any body help me in this..one more thing i want s to generate this should work dynamically...If we give any input .txt file the corresponding text should be convert into that format
__________________
visit :
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Reply With Quote
Sponsored Links