sed/awk remove newline


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sed/awk remove newline
# 1  
Old 08-11-2010
sed/awk remove newline

Hi,

I have input file contains sql queries i need to eliminate newlines from it.
when i open it vi text editor and runs

Code:
:%s/'\n/'/g

it provides required result. but when i run sed command from shell prompt it doesn't impact outfile is still same as inputfile.

Code:
shell] sed -e 's/'\n/'/g' inputfile.txt > outfile.txt

inputfile.txt
Code:
INSERT INTO test (column1,column2) VALUES ('column1value','
                  column2value');

i want outfile.txt as follows, need to get column1value and column2value at same line.

Code:
INSERT INTO test (column1,column2) VALUES ('column1value','column2value');

Thanks in advance.
# 2  
Old 08-11-2010
This should work:
Code:
awk -vORS="" '1' file

# 3  
Old 08-11-2010
hello,

thanks for your reply i will check it. Can you please explain this command.
Code:
awk -vORS="" '1' file

# 4  
Old 08-13-2010
Hello,

I tried this

awk -vORS="" '1' file

but this converting entire lines into single line. I need to do it for only test tables.

inputfile
Code:
INSERT INTO test (column1,column2) VALUES ('column1value','
                  column2value');
UPDATE test2 SET column1='column1value',
column2-'column2value' WHERE column1='column1value';

I require output file as follows:

Code:
INSERT INTO test (column1,column2) VALUES ('column1value','column2value');
UPDATE test2 SET column1='column1value',
column2-'column2value' WHERE column1='column1value';

Thank you.
# 5  
Old 08-13-2010
Code:
awk '{ if ($3 == "test")  printf("%s",$0);  else  printf ("%s\n",$0); }' file_name

# 6  
Old 08-13-2010
Code:
sed  '/INSERT/{N;s/\n[ \t]*//}' myfile

# 7  
Old 08-13-2010
A perl sol:

Code:
perl -p -e 's/([^;])\n|^\s+/\1/' file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed to remove newline chars based on pattern mis-match

Greetings Experts, I am in AIX; I have a file generated through awk after processing the input files. Now I need to replace or remove the new-line characters on all lines that doesn't have a ; which is the last character on the line. I tried to use sed 's/\n/ /g' After checking through the... (6 Replies)
Discussion started by: chill3chee
6 Replies

2. Shell Programming and Scripting

Want to remove / and character using awk or sed

Below i am trying to remove "/" and "r" from the output, so i need output as: hdiskpower3 hdisk0 hdisk1 #inq | grep 5773 | awk '{print $1}' | sed 's/dev//g' | awk -F"/" '{$1=$1}1' .....................................................//rhdiskpower0 //rhdiskpower1 //rhdiskpower2... (3 Replies)
Discussion started by: aix_admin_007
3 Replies

3. Shell Programming and Scripting

sed awk to remove the , in a string

Dear All, Can anyone help to remove the , bewteen "" in a string by using sed or awk? e.g. input : 1,4,5,"abcdef","we,are,here",4,"help hep" output:1,4,5,"abcdef","wearehere",4,"help hep" Thanks, Mimi (5 Replies)
Discussion started by: mimilaw
5 Replies

4. Shell Programming and Scripting

Remove letter from $1 using awk or sed

I have a file: 575G /local/mis/SYBDUMP I want to remove the G, K, M or T so I can use $1 in awk or sed to do math. I want to end up with a file containing: 575 /local/mis/SYBDUMP It should not matter how small or large the numeric numbers are so if 2, 3, 4, or 5 digits etc I want to see... (9 Replies)
Discussion started by: tamvgi
9 Replies

5. Shell Programming and Scripting

any savant ? using AWK/SED to remove newline character between two strings : conditional removal

I'd like to remove (do a pattern or precise replacement - this I can handle in SED using Regex ) ---AFTER THE 1ST Occurrence ( i.e. on the 2nd occurrence - from the 2nd to fourth occurance ) of a specific string : type 1 -- After the 1st occurrence of 1 string1 till the 1st occurrence of... (4 Replies)
Discussion started by: sieger007
4 Replies

6. Shell Programming and Scripting

remove newline between two string with sed command in unix shellscript

I have a file (test.dat) which contains data like this 459|199811047|a |b |shan kar|ooty| 460|199811047|a |bv |gur u|cbe| but I need it like: 459|199811047|a |b |shankar|ooty| 460|199811047|a |b |guru|cbe| While reading the data from this file, I don't want to remove newline from the end of... (4 Replies)
Discussion started by: jcrshankar
4 Replies

7. Shell Programming and Scripting

How to remove lines before and after with awk / sed ?

Hi guys, I need to remove the pattern (ID=180), one line before and four lines after. Thanks. (5 Replies)
Discussion started by: ashimada
5 Replies

8. Shell Programming and Scripting

a SED/AWK way to remove everything except...

Hi all, I have a logfile which has lines as following: DOMAIN\username,Deposit,DOMAIN\ServiceAccountName,25/03/2010,00:10,\\SERVER,,,,/Ts=4BAA9BD6,,,10.00,10.03 It's a log of a pcounter print charge system. I need to only have the first part (domain\username) and the second last... (4 Replies)
Discussion started by: necron
4 Replies

9. Shell Programming and Scripting

SED: how to remove newline after pattern?

Hi, I have the following XML not well-indented code: <hallo >this is a line </hallo> So I need to remove the newline. This syntax finds what I need to correct, but I don't know how to remove the newline after my pattern: sed 's/<.*$/&/' How can I subtract the newline after my... (1 Reply)
Discussion started by: nico.ben
1 Replies

10. Shell Programming and Scripting

sed ksh remove newline between 2 containers

If we assume that each line between the {} container is an XML document then What I want to remove the newline character from all lines within each container to have one XMDL document per line I wrote a bit of sed after trawling the web: e.g. #!/bin/sed -nf H /}/ { x s/\n//g p... (3 Replies)
Discussion started by: JamesJSC
3 Replies
Login or Register to Ask a Question