Ignore or specify multiple header rows from a csv file

bhussung

Hello all-

I have a flat file data source (csv file) that has multiple header lines (e.g.)

Site Name,CSO 1,CSO 1,CSO 2,CSO 2,CSO 3,CSO 3,CSO 4,CSO 4
Isco Quantity,Level,Velocity,Level,Velocity,Level,Velocity,Level,Velocity
Label,CSO 1Level,CSO 1Velocity,CSO 2Level,CSO 2Velocity,CSO 3Level,CSO 3Velocity,CSO 4Level,CSO 4Velocity
Units,ft,ft/s,ft,ft/s,ft,ft/s,ft,ft/s
Resolution, 0.001 , 0.01 , 0.001 , 0.01 , 0.001 , 0.01 , 0.001 , 0.01
Significant Digits,5,4,5,4,5,4,5,4

Then a blank line, then the data (date, level, velocity, etc).
This file is auto-generated daily by a proprietary piece of software.
I am wondering if I am missing something, but I need to know if there is anyway for Report Designer to strip out the header data so it can be graphed properly?

Thanks in advance.

mwilliams

Hi bhussung,

One thing you can do would be to create a computed column with the aggregation of count, then filter out the lines you don't want that way.