Using File-pattern and Column names

ag_ram · Post by **ag_ram** » Sun May 13, 2007 7:59 am

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?

ag_ram · Post by **ag_ram** » Sun May 13, 2007 8:43 am

It is easy !

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

ray.wurlod · Post by **ray.wurlod** » Sun May 13, 2007 4:14 pm

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