Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Remove newlines

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Remove newlines
# 1  
Old 02-28-2014
Network Remove newlines
Hi buddy's

my file are like this:
Code:
s.no,name,band,sal
1,"suneel",,10
2,"bargav
sand",,20
30,"
ebdug gil",,4

but i want
Code:
s.no,name,band,sal
1,"suneel",,10
2,"bargav sand",,20
30,"ebdug gil",,4

any command or Shell script for this.
please help me it's urgent to implement


Moderator's Comments:
Mod Comment Please use code tags next time for your code and data. Thanks
Last edited by vbe; 02-28-2014 at 10:37 AM..
# 2  
Old 02-28-2014
Quote:
please help me it's urgent to implement
We have a forum for that, but you need bits...
# 3  
Old 02-28-2014
Can there be comma's within the double quotes too? I am guessing there can be?



To add to VBE's remark:

---
Everyone at the UNIX and Linux Forums gives their best effort to reply to all questions in a timely manner. For this reason, posting questions with subjects like "Urgent!" or "Emergency" and demanding a fast reply are not permitted in the regular forums.

For members who want a higher visibility to their questions, we suggest you post in the Emergency UNIX and Linux Support Forum. This forum is given a higher priority than our regular forums.

Posting a new question in the Emergency UNIX and Linux Support Forum requires forum Bits. We monitor this forum to help people with emergencies, but we do not not guarantee response time or best answers. However, we will treat your post with a higher priority and give our best efforts to help you.

Thank you.

The UNIX and Linux Forums
# 4  
Old 02-28-2014
Network Remove newline
i checked all commands, but those r not working properly..
requirement is...I have csv file. that have duplicates also like
INPUT
Code:
no,name,band,sal
1,"suneel",,10
1,"ravi
kumar",,20
2,"
bang dulba",,20

OUTPUT
Code:
no,name,band,sal
1,"suneel",,10
2,"ravi kumar",,20
2,"bang dulba",,20

using shell script or commnad, how to solve this, plz help me.
Last edited by Scrutinizer; 02-28-2014 at 03:58 PM..
# 5  
Old 02-28-2014
Hello,

Please use code tage always for commands as per fourm rules.
Following may help you.

Code:
sed '3N;4s/\n/ /g' file_name | sed '4N;5s/\n/ /g'


Output will be as follows.

Code:
s.no,name,band,sal
1,"suneel",,10
2,"bargav sand",,20
30," ebdug gil",,4

Thanks,
R. Singh
# 6  
Old 02-28-2014
Thanks for the replying.. can u explain this command, because in that only i learn and next time i do it...

---------- Post updated at 01:26 PM ---------- Previous update was at 01:17 PM ----------

No singh, its not working..
i forwarding the my data.. i.e
Code:
10	Special Projects	bangaram	0		0
10	Statutory/ Internal Audit , MO reporting (incl Excel Spreadsheet uploadation)	bangaram	0		0
10	Complience with SVCCL	bangaram	0		0
10	"Release of incentives / commission to all channel partners.
"	bangaram	0		0
10	Timely processing of sales orders to channel partners	bangaram	0		0
10	Balance sheet Reviwe	bangaram	0		0
10	Ensuring Critical Reconciliation on monthly basis. (IN-GL)	bangaram	0		0
10	"Timely & accurate closure of Accounts.
"	bangaram	0		0
10	Timely calculation & releasing of Monthly prepaid related commissions & Postpaid ( AEO's)	bangaram	0		0
11	Opex Spend on communication activites	bangaram	0		0
11	Opex Spend on communication activites	bangaram	0		0
11	Visit	bangaram	0		0
11	Prospect	bangaram	0		0
11	Collection	bangaram	0		0
11	Revenu	bangaram	0		0
11	New Sales	bangaram	0		0
11	Yellow Belt Project	bangaram	0		0
11	CAG Score	bangaram	0		0
11	Revenue Focus	bangaram	0		0
12	Revenue Focus	bangaram	0		0
12	Performance Score card	bangaram	0		0
12	Performance Score card	bangaram	0		0
12	Airtel Stores Management	bangaram	0		0
12	CSMM	bangaram	0		0

Last edited by Scrutinizer; 02-28-2014 at 03:58 PM.. Reason: code tags
# 7  
Old 02-28-2014
Hello,

That command works only for given input.


Thanks,
R. Singh
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX file with Newlines

Hi Friends, I have a data file with new lines. How to remove the newlines and should be showed in one line. I tried using the command tr -d '\n' filename sed 's/\n//g' file name Ex: 1 abc hyd is actual record but in our scenario showing it as 1 abc hydthis record should be like... (5 Replies)
Discussion started by: victory
5 Replies

2. UNIX for Beginners Questions & Answers

Remove newlines and carriage return from a csv file using UNIX

I need to remove new lines and carriage returns from csv file. Is there anything other than sed and gwak by which we could achieve this ? Any suggestions ? (3 Replies)
Discussion started by: A_Gaddale
3 Replies

3. UNIX for Dummies Questions & Answers

Using find with awk to remove newlines

I want to list all html files present in a directory tree, the remove the newline and get one string with a space between files find /home/chrisd/Desktop/seg/geohtml/ -name '*.html' | awk BEGIN{FS=\r} '{print}' ---------- Post updated at 06:47 PM ---------- Previous update was at 06:25 PM... (5 Replies)
Discussion started by: kristinu
5 Replies

4. Shell Programming and Scripting

Need help with eliminating newlines with Perl

Good morning, I need some help with getting rid of newlines with the output from a MYSQL query and putting the information into the right format that I need. Here is the script as it is today: #!/usr/bin/perl my $uda = system("/opt/incontrol/mysql/bin/mysql -u root -ppassword... (2 Replies)
Discussion started by: brianjb
2 Replies

5. Shell Programming and Scripting

removing newlines after a certain word.

Hello! This is my first post here. I have a file with text like: A</title> B C</title> D I need to format it to: AB CD I am trying to use sed: sed 's/<//title>\n/ /g' file > newfile to delete </title> and the newline character, but the file is unchanged because there are... (3 Replies)
Discussion started by: DaytonCPS
3 Replies

6. Shell Programming and Scripting

Delete newlines after every one space

Hi All, I have a file which looks like this: abc 3456 computer 3214 printer 0.9823 computer 3214 Can anyone please let me know how I can format my text like this? abc 3456 computer 3214 printer 0.9823 computer 3214 I know how to space to newlines using tr but don't know how to do... (4 Replies)
Discussion started by: shoaibjameel123
4 Replies

7. Shell Programming and Scripting

sed remove newlines and spaces

Hi all, i am getting count from oracle 11g by spooling it to a file. Now there are some newline characters and blank spaces i need to remove these. pl provide me a awk/sed solution. the spooled file is attached. i tried this.. but not getting req o/p (6 Replies)
Discussion started by: rishav
6 Replies

8. Shell Programming and Scripting

Remove improperly placed newlines

Hello, there. I have a file that's a horrible, horrible mess. (Basically, it's an export from a firewall config.) The people who generated the file didn't think that putting a newline in the middle of a hostname would ever be a problem. It is. Here's an example of the stuff in the file: ... (2 Replies)
Discussion started by: mikesimone
2 Replies

9. Shell Programming and Scripting

Transpose with two newlines as delimiter

Hi Guys, I have data in a file as follows: a 1 2 3 b 4 5 6 a 6 7 8 a 4 7 9 b 6 8 5 c 0 8 7 So the number of rows which have data is variable (2 for the first group, one for the second group and three for the third group), but the delimiters between the... (10 Replies)
Discussion started by: npatwardhan
10 Replies

10. Shell Programming and Scripting

awk - need to remove unwanted newlines on match

Context: I need to remove unwanted newlines from a data file listing books and associated data. Here is a sample listing ( line numbers included ): 1 360762| Skip-beat! 14 /| 9781421517544| nb | 2008.| Nakamura, Yoshiki.| NAKAMUR | Kyoko Mogami followed 2 her true love Sho to Tokyo to... (6 Replies)
Discussion started by: Bubnoff
6 Replies
Login or Register to Ask a Question