foreach

Hi!

I have an directory containing several csv-files, e.g. test1, test2, test3.
And every file contains lines like 0,1,2,3,4 and 9,8,7,6,5

Now i want to create a new file (output.txt) with all of the lines of all of
the files.
No problem so far - but i must know, from which file the line came.

output.txt should look something like this:
test1,0,1,2,3,4
test1,9,8,7,6,5
test2,1,3,5,7,9
test2,2,4,6,8,0
....

Any Ideas?

Working on: Sun Microsystems Inc. SunOS 5.8 Generic Patch December
2002

Thanks,
-gue-

Re: foreach

In comp.unix.shell Guenther Kober :
> Hi!

> I have an directory containing several csv-files, e.g. test1, test2, test3.
> And every file contains lines like 0,1,2,3,4 and 9,8,7,6,5

> Now i want to create a new file (output.txt) with all of the lines of all of
> the files.
> No problem so far - but i must know, from which file the line came.

> output.txt should look something like this:
> test1,0,1,2,3,4
> test1,9,8,7,6,5
> test2,1,3,5,7,9
> test2,2,4,6,8,0
> ...

> Any Ideas?

Using GNU awk:

awk '{print FILENAME","$0}' test* > outfile

You want to use nawk or another awk on Solaris, NOT the one in
$PATH.

--
Michael Heiming (X-PGP-Sig > GPG-Key ID: EDD27B94)
mail: echo zvpunry@urvzvat.qr | perl -pe 'y/a-z/n-za-m/'
#bofh excuse 301: appears to be a Slow/Narrow SCSI-0 Interface
problem

Re: foreach

Guenther Kober wrote:
>
> Hi!
>
> I have an directory containing several csv-files, e.g. test1, test2, test3.
> And every file contains lines like 0,1,2,3,4 and 9,8,7,6,5
>
> Now i want to create a new file (output.txt) with all of the lines of all of
> the files.
> No problem so far - but i must know, from which file the line came.
>
> output.txt should look something like this:
> test1,0,1,2,3,4
> test1,9,8,7,6,5
> test2,1,3,5,7,9
> test2,2,4,6,8,0
> ...
>
> Any Ideas?
>
> Working on: Sun Microsystems Inc. SunOS 5.8 Generic Patch December
> 2002
>
> Thanks,
> -gue-

grep ^

--
Fred L. Kleinschmidt
Boeing Associate Technical Fellow
Technical Architect, Common User Interface Services
M/S 2R-94 (206)544-5225

Re: foreach

"Guenther Kober" wrote in message news:

>
> I have an directory containing several csv-files, e.g. test1, test2, test3.
> And every file contains lines like 0,1,2,3,4 and 9,8,7,6,5
>
> Now i want to create a new file (output.txt) with all of the lines of all of
> the files.
> No problem so far - but i must know, from which file the line came.
>
> output.txt should look something like this:
> test1,0,1,2,3,4
> test1,9,8,7,6,5
> test2,1,3,5,7,9
> test2,2,4,6,8,0
> ...


There are many ways to do it, some amongst them are as follows:


A) based on the for-do-done construct.

#!/bin/sh -u

for file in ./*; do

# method 1-> use of a while-do-done + printf
exec 3< $file
while IFS= read <&3 Line;do
printf '%s,%s\n' "$file" "$Line"
done
exec 3<&-

# method 2-> use of the 'nl' line numbering command + 'sed'
nl -s "${file}," < $file | sed -e 's/^[ ]*[0-9]*//'

# method 3-> 'perl' way
perl -ple'$_="${ARGV},$_"' "$file"

# method 4-> 'sed' editor Note: $file should be transformed if it contains
# characters that have any meaning to sed's s/// command's RHS.
sed -e "s:^:$file,:" < $file

# method 5-> xargs + printf
0< $file xargs -l1 printf '%s,%s\n' "$file"
done

You could do this way too: (assuming only files in your directory and no newline
in the filenames)

/bin/ls -1 | xargs perl -ple'$_="${ARGV},$_"'

Re: foreach

"Michael Heiming" wrote

>
> awk '{print FILENAME","$0}' test* > outfile
>

that's it!

thanks!
-gue-