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
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