Shell Programming and Scripting

hi,

i have some 37 files having a file name pattern 'stg*' which are tilde delimited files. the requirement is i need to fetch two columns
field1:filename
field2:first field of each file....
for example

if i have a file like stg_2345.txt having a content

Code:

1~2~3
4~5~6

another file
stg_1234.txt
having content

Code:

7~8~9

output should be

Code:

stg_2345.txt,1
stg_1234.txt,7

please help me with a unix command to do this


regards
Angel

Try this

Code:

 awk -F\~ '{if(FNR==1){print FILENAME,$1}else {next}}'  stg*

try this

Code:

for i in stg*; do echo "$i,"; head -1 $i | cut -d "~" -f1; done

Code:

awk -F"~" 'FNR==1{print FILENAME "," $1}' stg_*