Visit Our UNIX and Linux User Community


How can i join three lines into one in unix?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How can i join three lines into one in unix?
# 15  
Old 10-07-2009
Quote:
Originally Posted by vgersh99
I don't quite follow what you're after. Could you please provide a sample input file, a desired output and the sample values for 'string1' and 'string2'.
Please use BB codes when posting sample data.
Apologies. I have just re-edited the last post, I hope it's easier to understand now.

Thanks.
# 16  
Old 10-07-2009
Code:
nawk 'c && !--c {print (($0 ~/(alter|insert)/)? ORS: OFS) $0;next};/update/{c=1;printf $0;next}1' myFile

# 17  
Old 10-07-2009
Quote:
Originally Posted by vgersh99
Code:
nawk 'c && !--c {print (($0 ~/(alter|insert)/)? ORS: OFS) $0;next};/update/{c=1;printf $0;next}1' myFile

Perfect, thanks so much. I have learnt a lot. So fast answering too.. thousand times thank you.Smilie
# 18  
Old 10-07-2009
Quote:
Originally Posted by Kibou
input:

Code:
select <something><something>
update <something><something>
<something><something>
insert into <something><something>
select <something><something>
update <something><something>
alter table <something><something>
update <something><something>
insert into <something><something>

output:

Code:
select <something><something>
update <something><something><something><something>
insert into <something><something>
select <something><something>
update <something><something>
alter table <something><something>
update <something><something>
insert into <something><something>

Code:
awk '{printf (/^</)?$0:ORS$0}' file

# 19  
Old 10-08-2009
Quote:
Originally Posted by protocomm
try this...

Code:
awk '{if (NR%3) {ORS="";print " "$0} else {ORS="\n";print " "$0}}'
 file

Thank you protocomm, but I had what I needed. That doesnt search for a any pattern. Thanks anyways, it's helping me to understand how awk works Smilie

---------- Post updated at 11:00 AM ---------- Previous update was at 10:37 AM ----------

Quote:
Originally Posted by danmero
Code:
awk '{printf (/^</)?$0:ORS$0}' file

humm this returns what I need but I cant use it because the next line has not a reference string but the string in the line just before with the word "update" is the one I can use.

Thanks anyways Smilie

---------- Post updated at 11:18 AM ---------- Previous update was at 11:00 AM ----------

Quote:
Originally Posted by Kibou
Perfect, thanks so much. I have learnt a lot. So fast answering too.. thousand times thank you.Smilie
I have another problem..

When I have a "create table" I have several lines after, and then ");". I want to append all those lines but I dont know how many lines would it be, so the reference would be the final ");" line. How to add this new rule to the one you made before?? Smilie

Your last statement:

Code:
nawk 'c && !--c {print (($0 ~/(alter|insert)/)? ORS: OFS) $0;next};/update/{c=1;printf $0;next}1' myFile

So, I have found something like:

input:
Code:
select <something><something>
update <something><something>
<something><something>
insert into <something><something>
select <something><something>
update <something><something>
alter table <something><something>
update <something><something>
insert into <something><something>
create table <something><something>
<something><something>
);
select <something><something>
create table <something><something>
<something><something>
<something><something>
<something><something>
);
update <something><something>

output:

Code:
select <something><something>
update <something><something><something><something>
insert into <something><something>
select <something><something>
update <something><something>
alter table <something><something>
update <something><something>
insert into <something><something>
create table <something><something><something><something>);
select <something><something>
create table <something><something><something><something><something><something><something><something>);
update <something><something>

I am sorry this has turned into a more complex stuff.. thankful again.

---------- Post updated at 12:04 PM ---------- Previous update was at 11:18 AM ----------

Quote:
Originally Posted by Kibou
Thank you protocomm, but I had what I needed. That doesnt search for a any pattern. Thanks anyways, it's helping me to understand how awk works Smilie

---------- Post updated at 11:00 AM ---------- Previous update was at 10:37 AM ----------



humm this returns what I need but I cant use it because the next line has not a reference string but the string in the line just before with the word "update" is the one I can use.

Thanks anyways Smilie

---------- Post updated at 11:18 AM ---------- Previous update was at 11:00 AM ----------



I have another problem..

When I have a "create table" I have several lines after, and then ");". I want to append all those lines but I dont know how many lines would it be, so the reference would be the final ");" line. How to add this new rule to the one you made before?? Smilie

Your last statement:

Code:
nawk 'c && !--c {print (($0 ~/(alter|insert)/)? ORS: OFS) $0;next};/update/{c=1;printf $0;next}1' myFile

So, I have found something like:

input:
Code:
select <something><something>
update <something><something>
<something><something>
insert into <something><something>
select <something><something>
update <something><something>
alter table <something><something>
update <something><something>
insert into <something><something>
create table <something><something>
<something><something>
);
select <something><something>
create table <something><something>
<something><something>
<something><something>
<something><something>
);
update <something><something>

output:

Code:
select <something><something>
update <something><something><something><something>
insert into <something><something>
select <something><something>
update <something><something>
alter table <something><something>
update <something><something>
insert into <something><something>
create table <something><something><something><something>);
select <something><something>
create table <something><something><something><something><something><something><something><something>);
update <something><something>

I am sorry this has turned into a more complex stuff.. thankful again.
Another way of solving my problem would be a statement doing something just like finding a string1, deleting this line and the next lines until it finds another pattern in a line. This line that follows the other pattern wont be deleted.
If implementing this job, the last thing I requested before about "create table" wont be needed any more.
Also, if a line with just the string1 is found, delete that line.

It would be something like:

input:
Code:
select <something><something>
update <something><something>
insert into <something><something>
select <something><something>
<something><something>
<something><something>
insert into <something><something>
select <something><something>
<something><something>
 <something><something>
<something><something>
update <something><something>

output:
Code:
update <something><something>
insert into <something><something>
insert into <something><something>
update <something><something>

So I want to find the string /select/ in a line, delete it, and the next lines after, doesnt matter how many if they are not /(update | insert into)/ , for example.

Thank you.. and as I said, if doing this, I wont need to work what I said before about "create table".

---------- Post updated at 12:24 PM ---------- Previous update was at 12:04 PM ----------

Quote:
Originally Posted by Kibou
Thank you protocomm, but I had what I needed. That doesnt search for a any pattern. Thanks anyways, it's helping me to understand how awk works Smilie

---------- Post updated at 11:00 AM ---------- Previous update was at 10:37 AM ----------



humm this returns what I need but I cant use it because the next line has not a reference string but the string in the line just before with the word "update" is the one I can use.

Thanks anyways Smilie

---------- Post updated at 11:18 AM ---------- Previous update was at 11:00 AM ----------



I have another problem..

When I have a "create table" I have several lines after, and then ");". I want to append all those lines but I dont know how many lines would it be, so the reference would be the final ");" line. How to add this new rule to the one you made before?? Smilie

Your last statement:

Code:
nawk 'c && !--c {print (($0 ~/(alter|insert)/)? ORS: OFS) $0;next};/update/{c=1;printf $0;next}1' myFile

So, I have found something like:

input:
Code:
select <something><something>
update <something><something>
<something><something>
insert into <something><something>
select <something><something>
update <something><something>
alter table <something><something>
update <something><something>
insert into <something><something>
create table <something><something>
<something><something>
);
select <something><something>
create table <something><something>
<something><something>
<something><something>
<something><something>
);
update <something><something>

output:

Code:
select <something><something>
update <something><something><something><something>
insert into <something><something>
select <something><something>
update <something><something>
alter table <something><something>
update <something><something>
insert into <something><something>
create table <something><something><something><something>);
select <something><something>
create table <something><something><something><something><something><something><something><something>);
update <something><something>

I am sorry this has turned into a more complex stuff.. thankful again.

---------- Post updated at 12:04 PM ---------- Previous update was at 11:18 AM ----------



Another way of solving my problem would be a statement doing something just like finding a string1, deleting this line and the next lines until it finds another pattern in a line. This line that follows the other pattern wont be deleted.
If implementing this job, the last thing I requested before about "create table" wont be needed any more.
Also, if a line with just the string1 is found, delete that line.

It would be something like:

input:
Code:
select <something><something>
update <something><something>
insert into <something><something>
select <something><something>
<something><something>
<something><something>
insert into <something><something>
select <something><something>
<something><something>
 <something><something>
<something><something>
update <something><something>

output:
Code:
update <something><something>
insert into <something><something>
insert into <something><something>
update <something><something>

So I want to find the string /select/ in a line, delete it, and the next lines after, doesnt matter how many if they are not /(update | insert into)/ , for example.

Thank you.. and as I said, if doing this, I wont need to work what I said before about "create table".
That is, if I would have a pattern to say "delete this line when you find this pattern" I would simply say:

Code:
sed '/^select/,/update$/d' myfile

but the problem is that I dont want it to delete the line with update, but the line just before when it finds it :s

I keep trying.. I am really new to this awk/sed world..
# 20  
Old 10-08-2009
Quote:
Originally Posted by Kibou
I am sorry this has turned into a more complex stuff.. thankful again.
Your requirement change from post to post. Try to decide what you need and post a data sample and required output.
# 21  
Old 10-08-2009
Quote:
Originally Posted by danmero
Your requirement change from post to post. Try to decide what you need and post a data sample and required output.
Apologies for the confusing posts..

This is what I want: if "select" found in a line -> delete that line. Delete also the lines afterwards until it finds "update" in a line, but I dont want this line to be deleted, just the line before.

It would be something like:

input:

Code:
select <something><something>
update <something><something>
insert into <something><something>
select <something><something>
<something><something>
update <something><something>
select <something><something>
<something><something>
<something><something>
<something><something>
update <something><something>

output:
Code:
update <something><something>
insert into <something><something>
insert into <something><something>
update <something><something>

That would be: clearing out all the lines with "select" and the lines that goes afterwards until it finds "update", but not deleting the line with "update".
I know I could simply do it like this,

Code:
      sed '/^select/,/^update/d' myfile

but the problem is that I dont want it to delete the line with update, but the line just before when it finds it :s

Thank you,.. I dont know if this is possible. Sorry I was making a mess but there are several ways of getting the final result I want, and I just want to give to you the easiest way to have it done... thanks again

Last edited by Kibou; 10-08-2009 at 08:26 AM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #914
Difficulty: Medium
In bash, grep -v -e '^[[:space:]]*$' file.txt will filter all the blank lines from file.txt and save the results in a file called file.txt.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Join Lines

Hi how do I join files like below in script. Thanks, Ashan there are may line like this in the file. zone name DR_TMP_A_sev1_3eA vsan 200 pwwn 50:00:09:73:f0:16:35:08 pwwn c0:50:76:08:6e:dc:00:16 zone name DR_TMP_A_SVR2_3eA vsan 200 pwwn 50:00:09:73:f0:16:35:08 pwwn... (4 Replies)
Discussion started by: ashanabey
4 Replies

2. UNIX for Dummies Questions & Answers

how to join all lines in afile in unix

Hi, I have a unix file which has many lines, i need to join all the lines to single line. Eg: myfile.txt contains: a 123 45fg try and i need the output as : a 123 45fg try Please help me on this. Thanks! (2 Replies)
Discussion started by: RP09
2 Replies

3. Shell Programming and Scripting

Help in unix script to join similar lines of input

Hi, I have been thinking of how to script this but i have no clue at all.. Could someone please help me out or give me some idea on this? I would like to group those lines with the same first variable in each line, joining the 2nd variables with commas. Let's say i have the following input. ... (3 Replies)
Discussion started by: rei125
3 Replies

4. Shell Programming and Scripting

join lines in file

I have a file like this: --------------------------------------------------------------- 26 00:04:48,440 --> 00:04:51,440 I don't know why he can't just do the Great Apache Flaming Arrow Act. 27 00:04:52,440 --> 00:04:54,839 Didn't you tell him to use the gopher snake? 28... (1 Reply)
Discussion started by: thailand
1 Replies

5. Shell Programming and Scripting

join two lines

I want to join this two lines but only when after him I have nothing or a comma Yes, I know Jonesy, and I'll give him about one more minute. this two lines must become Yes, I know Jonesy, and I'll give him about one more minute. thank you very much (11 Replies)
Discussion started by: thailand
11 Replies

6. Shell Programming and Scripting

join 2 lines

hi all i have sample and i need script to do this /dev/xxx oracle test /dev/sap 9999 000 88 99 i need the out put like this /dev/xxx oracle test /dev/sap 9999 000 88 99 can any one provide me with an idea to solve this problem (8 Replies)
Discussion started by: maxim42
8 Replies

7. Shell Programming and Scripting

Join the lines

Hi All, Currently, the output looks like this: hdisk0 queue_depth:3 hdisk1 queue_depth:3 hdisk2 queue_depth:1 hdisk3 queue_depth:1 I need to change the format to look like this: hdisk0 queue_depth:3 hdisk1 queue_depth:3 hdisk2 queue_depth:1 (8 Replies)
Discussion started by: Beginer0705
8 Replies

8. Shell Programming and Scripting

join lines

input1 x x input2 y x x z join input1 input2>>output ouput x x (2 Replies)
Discussion started by: repinementer
2 Replies

9. UNIX for Dummies Questions & Answers

how to join lines

can anyone tell me as "how to join all lines in a file " using a shell script Actually i have many files in a directory and for each file i want to join all the lines using a shell scrip . Thanks in advance!!! (8 Replies)
Discussion started by: glamo_2312
8 Replies

10. Shell Programming and Scripting

join two lines together

Hi, I have a file with on one line a uid, and on the next line a date. I am trying to make the to into one line. Here's an example: koppx 20031125 kraan 20031119 sarox 20031107 And this is what i want it to be: koppx;20031125 kraan;20031119 sarox;20031107 I have been trying... (4 Replies)
Discussion started by: tine
4 Replies

Featured Tech Videos