Page 1 of 1

Using File-pattern and Column names

Posted: Sun May 13, 2007 7:59 am
by ag_ram
Hi Folks

I use file pattern to read a set of .csv files. In each of these files , the first name is column names. I have set the "First row is column names" to true , It works when there is one file with that pattern name and fails when there are many files matching that pattern.

Any ways of resolving this from DS or using UNIX scripts?

Posted: Sun May 13, 2007 8:43 am
by ag_ram
It is easy !

sed -e '1d' filepattern* > file.csv

Posted: Sun May 13, 2007 4:14 pm
by ray.wurlod
It doesn't fail - you merely get import warnings which, if these are the only ones, can be ignored (or even demoted to informational in this job).