UNIX for Dummies Questions & Answers

Hi,

Do you know given a file which is SED at the same time, how to read it and AWK it in tabs format.

Means:-

I have an input file which is (at the same time perform sed):-

1
2
3
4
5
6
7

I would like to print out in tab format which is:-

1 2 3 4 5 6 7 ....

And another thing I observe in the past when I have data in tab format..when i perform operation on these fields it doesnt work. Because the tab data will go to new line and as a result the field number has got confused.

Anyone can help on this..Appreciate alot!


-Jason

I am not sure I completely understand what you want, but you can use tr for the same purpose

cat $input_file | tr '\012' '\011'

Actually my input is something like:-

1 10 blablabla
1 11 abababa
1 14 dslsdlsls
.
.
.
.
N

I have already used SED and cut to extract the first field and AWK to print the first element..however, I would like these data to be in tab format.

1 1 1 . . .N


I tried something like
cat bla.txt| sed '/^[^0-9-]/d' | cut f1 |awk '{print $1 "\t\t" }'
but it doesnt work.


Hope you could get I mean now.;Thanks.

-Jason

.... with all the cat/sed/cut and awk-ing.... it's kinda hard to understand the desired final result.
Pls provided a sample input AND a desired output - make it as representative as possible.

I think you want this:

Code:

nawk '{printf("%s%s", (FNR==1) ? "" : "\t", $1} END{print ""}' myInputFile

awk '{printf ("%s\t", $1) ;}' bla.txt

or

cat bla.txt | cut -d ' ' -f 1 | tr -s '\012' '\011'

Hope it helps
J.

Hi,

I tried to use the below command:-
cat bla.txt | sed 's/^[ ]*//' |sed 's/^-/0/'|sed 's/^#####/0/'|sed '/^[^0-9-]/d'|tr ':' "," |tr '' "//"| awk '{printf ("%s\t",$1); }'> output.txt


And I get this output.
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0

I would like to remove those whitespaces and get ultimately:-

0,0,0,0,0,0,0,0,0,0,0,0,0,0


Please advise. Thanks.


-Jason

Hi,

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

It just works.

However I have one query,

Given that I have two separate folders which contain multiple bla.txt, how can i extract each of these bla.txt from two folders and the information is stored as one file (which is output.txt)?

Assuem i have Folder A and Folder B. In folder A, I have ten files with bla1.txt,bla2.txt....bla10.txt. Same goes in Folder B with bla11.txt to bla20.txt.

I would like to extract the information such that 0,0,0,............ for each of the txt found in two folders and merge in output.txt.

Please advise.

Thanks.

-Jason