Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How do I use paste command in while condition??

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How do I use paste command in while condition??
# 1  
Old 02-14-2013
How do I use paste command in while condition??
there are lot of files where in mostly all the file contains 2columns
Code:


Code:



Al,1
Ail,13
Al,3
Al,1
Al,3
Al,2
Al,3
Al,1
Al,1
Al,1

My requirement is i wanted only the second column of every file as a column ony in the base file... I used paste command... but it is not helping as I'm using while condition.

Code:


Code:



while read dline
do
while read opline
do
grep $dline Combo_31Jan.csv|grep -i "$opline" |awk -F, '{print $1","$7}'>>combo_operncount.$dline.$opline
done < operator.txt
done < date.txt
while read dline
do
>blank.$dline
while read opline
do
#paste blank.$dline combo_operncount.$dline.$opline >> FC7DFILE.$opline

#mv FC7DFILE.$opline blank.$dline
done < operator.txt
done < date.txt

operator.txt and date.txt contains

Code:


Code:



operator.txt

AEL
AL
TMO
VOE

date.txt

2013-01-28
2013-01-29
2013-01-30
2013-01-31

# 2  
Old 02-14-2013
It would be better if you could provide desired output and all the inputs.

Regards,

Pamu
# 3  
Old 02-14-2013
input

Code:


Code:



head combo_operncount.2013-01-31.VOD

vone,12
vone,4
vone,1
vone,3
vone,3
vone,1
vone,1
vone,1
vone,1
vone,1

similar to this I have several files classified on basis of date..

head combo_operncount.2013-01-30.VOD

vone,3
vone,1
vone,1
vone,3
vone,1
vone,1
vone,1
vone,3
vone,3
vone,1

My requirement is I want o/p to be in the below format

vone,12,3,.....,... it goes on , total from 2nd col to last
vone,4,1
vone,1,1
vone,3,3
vone,3,1
vone,1,1
vone,1,1
vone,1,3
vone,1,3
vone,1,1


the final o/p wil be with total and the and all othe columns

---------- Post updated at 12:58 PM ---------- Previous update was at 12:56 PM ----------

PS: there are some files which have lesser number of lines so i want that to be replaced to 0 and then i want the total...
# 4  
Old 02-14-2013
Try sth like this..

Code:
awk -F, '{A[FNR]=A[FNR]?A[FNR] FS $NF?$NF:"0":$0;
        if(FNR>t){t=FNR}}
        END{for(i=1;i<=t;i++){print A[i]}}' file1 file2

# 5  
Old 02-14-2013
what are file1 & file2 ??

It aint working Pamu,I don't see column 1 as well....

---------- Post updated at 01:36 PM ---------- Previous update was at 01:23 PM ----------

input

Code:


Code:



ale,27
ale,1
ale,12
ale,5
ale,3
ale,3
ale,1
ale,1
ale,1

==> combo_operncount.2013-01-29.ALE <==
ale,65
ale,38
ale,2
ale,1
ale,7
ale,16
ale,1
ale,2
ale,2
ale,4

==> combo_operncount.2013-01-30.ALE <==
ale,45
ale,13
ale,1
ale,1
ale,1
ale,1
ale,9
ale,3
ale,2
ale,3

==> combo_operncount.2013-01-31.ALE <==
ale,41
ale,20
ale,1
ale,1
ale,9
ale,12
ale,1
ale,3
ale,2
ale,5

required o/p

Code:


Code:



ale,57,65,45,41
ale,27	,38	,13	,20
ale,1	,2	,1	,1
ale,12	,1	,1	,1
ale,5	,7	,1	,9
ale,3	,16	,1	,12
ale,3	,1	,9	,1
ale,1	,2	,3	,3
ale,1	,2	,2	,2
ale,1	,4	,3	,5

---------- Post updated at 01:39 PM ---------- Previous update was at 01:36 PM ----------

there are several files like this whic are classified based on the date....
these files are also generated from some script.

there are few files with different count of lines

for ex

A contains 100 lines
B contains 120 lines
C contains 130 lines

then every file shul hav 130 line and the 2nd column for A & B file which has lesser line shul hav 0 as value....
# 6  
Old 02-14-2013
Your last requirement "undefined lines should have 0 value" applies for a matrix (two dimensional array).
Which GNU/Posix awk:
Code:
awk -F, '
FNR==1 { ++xm }
FNR>ym { ym=FNR }
{ a[FNR,xm]=$2 }
END {
for(y=1;y<=ym;y++) {
  for(x=1;x<=xm;x++) printf FS "%d",a[y,x]
  printf "\n"
 }
}' file1 file2 ... fileN

This User Gave Thanks to MadeInGermany For This Post:
nikhil jain
# 7  
Old 02-15-2013
hi how can i display the 1st column??? It aint displaying 1st column
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Issue with paste command

Hi, I am facing issue with paste command. It is adding spaces or tab in between. I have say 3 files with below data File_1 TH THI THIS I File_2 IS IS S IS RE S File_3 RECORD 1 CORD 2 IS RECORD 3 (3 Replies)
Discussion started by: Simanto
3 Replies

2. UNIX for Advanced & Expert Users

Paste command formatting

Hi, I was trying to concatenate some files using paste command along with some formatting but getting stuck. The problem is: cat 1.txt A cat 2.txt B C cat3.txt D E cat 4.txt G H (5 Replies)
Discussion started by: abhi1988sri
5 Replies

3. UNIX for Dummies Questions & Answers

paste command without spacing?

I'm trying to combine text files without a space. So if i use the paste command paste file1 file2 file3 > file4 the new file created has spacing between the contents of the once individual files. Is there some trick I can do with a delimiter that removes the spaces.. like paste -d'' or... (1 Reply)
Discussion started by: steveinthebox
1 Replies

4. Shell Programming and Scripting

Paste command - question

Hi, Below file content is output from pasting two files. Now, i want to output another file which just contains the difference on any line For example: JAY,2,,3,5,B+,JAY,2,,3,5,B+ ANN,5,,5,1,C,ANN,5,,5,2,C Line JAY seems to have no difference. However, line ANN has difference in on... (3 Replies)
Discussion started by: jakSun8
3 Replies

5. Shell Programming and Scripting

Can't paste in command line.

Hello. I've made a simple script which asks the user to input a hash and then runs a command that replaces the variable $hash with what the user inserted. The ting is that when the programm asks for input I can't paste anything there..! any clues?? :wall: (8 Replies)
Discussion started by: louboulos
8 Replies

6. Shell Programming and Scripting

redirect stdout echo command in condition A run in condition B

hi, I have some problems in my simple script about the redirect echo stdout command inside a condition. Why is the echo command inside the elif still execute in the else command Here are my simple script After check on the two diff output the echo stdout redirect is present in two diff... (3 Replies)
Discussion started by: jao_madn
3 Replies

7. UNIX for Dummies Questions & Answers

paste command

input1 15 150 input2 x 10 100 input3 y 20 200 z 34 44 cmd paste -d "\t" input1 input2 input3 >>output output (1 Reply)
Discussion started by: repinementer
1 Replies

8. Shell Programming and Scripting

command paste with variables

Hi. I have an interesting problem and i couldn't find out the solution. I have two variables in which there are a lot of lines finished by \n. I would like to concatenate this two variables into one in this format: var1var2 var1var2 . . . I could do this simply by command paste but it works... (32 Replies)
Discussion started by: samos
32 Replies

9. Shell Programming and Scripting

Paste command issue

Problem with Paste command :) Hi All, i need small suggestion in my below script... i have output in .txt format like below file1.txt 01111111 02222222 03333333 file2.txt 230125 000012 000002 now i want to merge both the file in xls or csv formate now i am using the below... (2 Replies)
Discussion started by: Shahul
2 Replies

10. UNIX for Advanced & Expert Users

paste command

I wonder if any body can help me with a command i am struggling with. I have a file with around 400 lines in, in a program i have it pulls out each line at a time so that data from the line can be cross referenced with another file. If it finds a match it pulls out a ocde from the second file, this... (5 Replies)
Discussion started by: mariner
5 Replies
Login or Register to Ask a Question