Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Skip rows and begin reading at certain interval

Status
Not open for further replies.

sap1958

Technical User
Oct 22, 2009
138
US
Here are two sample files

Changes for 2001
Fee TestCode TestName EffDate Amt
C1 1125 M, Stanley 6/1/2001 300
C2 1126 C. Smith 5/1/2001 500

Changes for 2002

Fee TestCode TestName EffDate Amt

C1 1125 M, Stanle 6/1/2001 300
C2 1126 C, Smith 5/1/2001 500

1. In all instances I want to skip any spaces in the rows and begin reading data beginning with the word Fee. As you can see, in some cases data is underneath Fee. In some cases column Fee is separated by a row space. In addition, I notice that there is a row space at the beginning of the report so the data actually begins on line 2 with the words "Changes to" Is it as simple as using dlm = ' '; and will that work with suppressing rows with empty space. Desired output is
Fee TestCode TestName EffDate Amt
C1 1125 M, Stanley 6/1/2001 300
C2 1126 C. Smith 5/1/2001 500

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top