UNIX for Dummies Questions & Answers

Hi,

Another problem I faced is in the below cases of

cat bla.txt | sed 's/^[ ]*//' |sed 's/^-/0/'|sed 's/^#####/0/'|sed '/^[^0-9-]/d'|tr ':' "," |tr '' "//"| awk '{printf ("%s",$1); }'> output.txt

I would like to include the first element with filename which is
something like

bla, 0,0,0,0,0,0,............
test,0,0,0,1,0,.............

and so on.

I tried

awk '
{
printf("%s",$1);
printf("\n");

}'>output.txt

But it gives me something like

0,
0,
0,
0,
0,

I would like to output something like:-


bla, 0,0,0,0,0,0,............ "\n(new line)"
test,0,0,0,1,0,.............

Please advise. Thanks.

Rgrds,
Jason

Code:

awk '
FNR==1 {
   out=substr(FILENAME, 1, index(FILENAME, ".txt")-1)
}
{
   printf("%s%s%s\n",out, OFS,$1);
}' *.txt > output.txt

Hi,

I tried on the below code but it doesnt work at all. The execution get stuck

Actually, I can get the string name for filename manually by using
filters=${x:37}

And I would like to read in multiple files of .txt.And end up having these string on the front of the numbers which are extracted for each file.

For example:-
I have 2 files which is bla1.txt and bla2.txt which contains all the numbers to parse horizontally with "," in another new file; called output.txt

In the output.txt, it would be expected to have :-
bla1,1,0,0...........
bla2,1,0,1,...........

I have this code:-

echo $PWD
for x in /home/*; do

filters=${x:37}

cat *.txt| sed 's/^[ ]*//' |sed 's/^-/0/'|sed 's/^#####/0/'|sed '/^[^0-9-]/d'|tr ':' "," |awk '
{

printf ("%s",$1);

}

{

printf("\n");}'> output.txt

But I do not know where to include the $filters in front of each file (.txt) parsed. Besides, the "\n" doesnt work for each file parsed.

Please advise. Thanks alot.


-Jason

Hi,

I managed to it works. Something to share with you guys.

I used the number ${t:37} to get the number of the file

The code looks below:-

cat b$number| sed 's/^[ ]*//' |sed 's/^-/0/'|sed 's/^#####/0/'|sed '/^[^0-9-]/d'|tr ':' "," |awk '{printf ("%s",$1);}'| awk 'FNR == 1 && NR > FNR { print "" } { print $0 ",bla" }' >>output.txt

basically sed the files and print the first field of the file and at the end just append the "bla" behind each file read.

Appreciate alot help. Thanks again!

-Jason

Hi vgersh and all,

I have another query related to below ones.

Basically the command below just seeded some of the elements in a file.
I still missed out one thing which I would like to remove the first five lines of each file before awk is performed.

In other words, I only want to consider only from first 6th line on wards.

Please advise. THanks.

-Jason

I managed to get it work anyhow by doing on:-

sed '1,5 d' //which is to remove first 5 lines of the file


Thanks.

-Jason