Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Repeat line convert upper line

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Repeat line convert upper line
# 1  
Old 10-03-2013
Repeat line convert upper line
HI Guys,

My Input :-

Code:
R3 AV44 50 0 100 100 100
R3 AV44 1 0 100 100 100
R3 AV45 50 0 100 100 100
R3 AV45 0 3 100 100 100
R3 AV45S 50 0 100 100 100
R3 AV45S 0 4 100 100 100


Output :-

Code:
R3 AV44 50 0 100 100 100 1 0 100 100 100
R3 AV45 50 0 100 100 100 0 3 100 100 100
R3 AV45S 50 0 100 100 100 0 4 100 100 100

Repeat data base on column 2 move with upper line.
# 2  
Old 10-03-2013
An awk approach:
Code:
awk '
        {
                V = $0
                sub ( /[^ ]*[ ][^ ]*[ ]/, X, V )
                if ( !(A[$1,$2]) )
                        A[$1,$2] =  V
                else
                        A[$1,$2] = A[$1,$2] OFS V
        }
        END {
                for ( k in A )
                        print k, A[k]
        }
' file

# 3  
Old 10-03-2013
can we convert to one line command Smilie If possible
# 4  
Old 10-03-2013
Quote:
Originally Posted by pareshkp
can we convert to one line command Smilie If possible
Why don't you show us what one liner(s) you have tried...
# 5  
Old 10-03-2013
Hi,
Code:
$ cat file.txt
R3 AV44 50 0 100 100 100
R3 AV44 1 0 100 100 100
R3 AV45 50 0 100 100 100
R3 AV45 0 3 100 100 100
R3 AV45S 50 0 100 100 100
R3 AV45S 0 4 100 100 100

Code:
$ paste -d' ' - - <file.txt | cut -d' ' -f1-7,10-
R3 AV44 50 0 100 100 100 1 0 100 100 100
R3 AV45 50 0 100 100 100 0 3 100 100 100
R3 AV45S 50 0 100 100 100 0 4 100 100 100

Regards.
# 6  
Old 10-03-2013
Both Solution's are perfect Smilie
# 7  
Old 10-03-2013
Try
Code:
awk '{x=$0; getline; $1=$2=""; $0=x $0}1' file
R3 AV44 50 0 100 100 100  1 0 100 100 100
R3 AV45 50 0 100 100 100  0 3 100 100 100
R3 AV45S 50 0 100 100 100  0 4 100 100 100

EDIT: If you need to get rid of the double space, add ; gsub (/ */," ") before the closing bracket.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Get an output of lines in pattern 1st line then 10th line then 11th line then 20th line and so on.

Input file: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 (6 Replies)
Discussion started by: Sagar Singh
6 Replies

2. Shell Programming and Scripting

awk sed to repeat every character on same position from the upper line replacing whitespace

Hello is it possible with awk or sed to replace any white space with the previous line characters in the same position? I am asking this because the file I have doesn't always follow a pattern. For example the file I have is the result of a command to obtain windows ACLs: icacls C:\ /t... (5 Replies)
Discussion started by: nakaedu
5 Replies

3. Shell Programming and Scripting

Help with replace comma with new line and repeat the content

Input file G A G A,T A C A G,T,C T C . . Desired Output file G A G A G T A C A G A T A C T C (4 Replies)
Discussion started by: perl_beginner
4 Replies

4. UNIX for Dummies Questions & Answers

Convert lowercase to upper case in Sparc

Hi, I need to convert the hostname to uppercase and attach it to a string. eg: $hostname output mymac Final output should be Production.MYMAC (3 Replies)
Discussion started by: mohtashims
3 Replies

5. Shell Programming and Scripting

Repeat command with new variable for each line in txt file

Well here is my question. Let's say I have this Script: find /var/mobile/ maxdepth -2 name "$x" >> /"$x".txt The thing is I want to repeat this script and pull out a variable from a text file like this (each line = new variable $x and another run of the whole command) Thanks for... (27 Replies)
Discussion started by: pasc
27 Replies

6. Shell Programming and Scripting

convert single line output to multiple line

Hi all, I have a single line output like below echo $ips 10.26.208.28 10.26.208.26 10.26.208.27 want to convert above single line output as below format. Pls advice how to do ? 10.26.208.28 10.26.208.26 10.26.208.27 Regards Kannan (6 Replies)
Discussion started by: kamauv234
6 Replies

7. Shell Programming and Scripting

convert fields on each line to one line

Hello, I have a text file with the following fields: RecordNumber Name Email Date Notes Confirmed MailingList The problem is that each field is on a separate line. These seven fields repeat for the length of the file. What I want to do is to have a bash script or similar unitil EOF... (6 Replies)
Discussion started by: vestport
6 Replies

8. Shell Programming and Scripting

how to read the contents of two files line by line and compare the line by line?

Hi All, I'm trying to figure out which are the trusted-ips and which are not using a script file.. I have a file named 'ip-list.txt' which contains some ip addresses and another file named 'trusted-ip-list.txt' which also contains some ip addresses. I want to read a line from... (4 Replies)
Discussion started by: mjavalkar
4 Replies

9. Shell Programming and Scripting

how to convert from upper to lower case

Hi I am working in ksh and need to convert the following line into lower case: N344 N228 P227 N115 P116 N332 P331 P343 P293 N342 N294 N335 N329 P330 P336 P097 P092 N098 P334 N337 P345 P338 N091 N333 so the output should look like this: n344 n228 p227 n115 p116 n332 p331 p343 p293 n342... (5 Replies)
Discussion started by: aoussenko
5 Replies

10. Shell Programming and Scripting

after i convert upper case to lowercase

If user chosen to tolower then it should convert file name to lower or vice versa. when file names converted it should put into appropriate subdirectories. e.g when files converted it then seperate them out with file etension where it will seperate them out . such as file.pdf, phone.doc both... (1 Reply)
Discussion started by: Alex20
1 Replies
Login or Register to Ask a Question