How to extract data from a text file

negixx · #1 (**permalink**) 07-19-2005

Hello All,

Is there an easy way to extract data from a text file? The text file is actually a dump of a 2 page report with 6 columns and 122 lines. Example is

Report Tile

Type Product 1 Product 2 Product 3 Product 4 Product 5

Budget

Current
MTD
YTD.

Payments

Second Page of Report :
Report Tile

Type Product 6 Product 7 Product 8 Product 9 Grand Total

Budget

Current
MTD
YTD.

Payments

Say we only want to get the amount in :
Current - Product8, Product 9 and grand total.
MTD - Product8, product9 and Grand total
YTD - product8, product9 and Grand Total

Checking the text file, these are in rows 81, 82 and 83.

Thanks!

negixx

Ygor · #2 (**permalink**) 07-19-2005

Maybe try something like...

Code:

awk 'NR>=81 && NR<=83 {print $4, $5, $6}' file1

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
c program to extract text between two delimiters from some text file	kukretiabhi13	High Level Programming	7	12-03-2008 06:29 PM
how to extract columns from a text file	ihot	Shell Programming and Scripting	16	05-05-2008 11:33 PM
How to extract text from xml file	chrisf	Shell Programming and Scripting	3	09-01-2007 02:25 PM
Extract data from file	getdpg	Shell Programming and Scripting	20	08-03-2006 03:54 AM
extract data from file	apalex	Shell Programming and Scripting	2	04-27-2002 01:24 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by