|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Advanced & Expert Users Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD. |
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 |
| Help me clean this up | scanner248 | UNIX for Dummies Questions & Answers | 1 | 10-15-2007 05:31 PM |
| Clean File | kris01752 | UNIX for Advanced & Expert Users | 5 | 09-28-2006 11:40 AM |
| Clean file in single action | djp | Shell Programming and Scripting | 1 | 06-19-2006 06:34 PM |
| grep multiple text files in folder into 1 text file? | coppertone | UNIX for Dummies Questions & Answers | 7 | 08-23-2002 03:50 PM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
08-24-2006
|
||||
|
||||
|
Clean Text File
HI,
I have a file which comes from crystal reports in the below format. I need to clean the file so that i will only have the columns(deptid,empid,ename,sal) and the data below the column names. There is a bug in the repoting tool( we only see page1-1 for every department).The rundate change dynamically and the number of departments changes dynamically. Rpt 001 - Employee Master RunDate:08/03/2006 Parameter Employee: ALL Sal: ALL deptid empid ename sal 100 1 Thomas 2000 100 2 Brian 7000 Page -1 of 1 Rpt 001 - Employee Master RunDate:08/03/2006 Parameter Employee: ALL Sal: ALL deptid empid ename sal 200 1 Thomas 2000 200 4 Brian 7000 Page -1 of 1 Rpt 001 - Employee Master RunDate:08/03/2006 Parameter Employee: ALL Sal: ALL deptid empid ename sal 300 4 Thomas 2000 300 5 Brian 7000 Page -1 of 1 Can some one help me in writing the script |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
