Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Removal of carriage returns from a comma delimited file
Top Forums Shell Programming and Scripting Removal of carriage returns from a comma delimited file Post 302489541 by mahish20 on Thursday 20th of January 2011 05:02:30 PM
Old 01-20-2011
Removal of carriage returns from a comma delimited file
Hi,

I have a file which is having some carriage return in one of the field for which single line is coming in multiple lines.

I want to combine all those multiple lines of that field into one line.

Eg:

Input:

Code:
 
Id, Name, Location, Comments, Dept
2, John, US, I am from US.
I live in NC.
I am working on Unix, Finance
3, Jack, UK, I am from UK.
I live in London, Accounts

Desired Output:

Code:
Id, Name, Location, Comments, Dept
2, John, US, I am from US.I live in NC.I am working on Unix, Finance
3, Jack, UK, I am from UK.I live in London, Accounts

Any solution for this would be of really helpful.. Thanks.

Mahesh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comma Delimited file

I have a comma delimited file that sometimes has addresses details in. The problem is that the address detail can be seen as: "Sample House, Sample Road". When I run a script specifying the file is comma delimited I would like it to ignore comma's that are in between speech marks. Is this... (2 Replies)
Discussion started by: dbrundrett
2 Replies

2. Shell Programming and Scripting

Converting Tab delimited file to Comma delimited file in Unix

Hi, Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies

3. UNIX for Advanced & Expert Users

Issue with Removing Carriage Return (^M) in delimited file

Hi - I tried to remove ^M in a delimited file using "tr -d "\r" and "sed 's/^M//g'", but it does not work quite well. While the ^M is removed, the format of the record is still cut in half, like a,b, c c,d,e The delimited file is generated using sh script by outputing a SQL query result to... (7 Replies)
Discussion started by: sirahc
7 Replies

4. Shell Programming and Scripting

removal of return carriage baffling me?

hi ALL, bash-3.00$ echo $BASH_VERSION 3.00.16(1)-release I'm stumped on a bug. Im extracting a checksum value at the end of a file and storing it in a variable, the problem is that it is also somehow storing the carriage return in the string as show below: The variables below both... (4 Replies)
Discussion started by: satnamx
4 Replies

5. Shell Programming and Scripting

removing carriage returns in text file

Hi I have a text file that looks like this: A B C D E F G H I I want it to be reformatted to A;B;C; D;E;F; G;H;I; (4 Replies)
Discussion started by: coolnfunky
4 Replies

6. UNIX for Dummies Questions & Answers

Comma delimited file

Hi All, I have output of sql saved in comma separated file. Now i need to read line by line this file and assign word to a unix variable for further processing Eg: Test file world, 1, 3, 4 earth,2,3,4,5 moon,1,2,3,4 Output should be word1= world word2=1 echo " first word... (7 Replies)
Discussion started by: gwrm
7 Replies

7. Emergency UNIX and Linux Support

Adding carriage returns to file using sed/awk

Hello, I need help adding carriage returns at specific intervals (say 692 characters) to a text file that's one continous string. I'm working in AIX5.3. Any quick help is appreciated. Thanks! (2 Replies)
Discussion started by: bd_joy
2 Replies

8. UNIX for Advanced & Expert Users

Add a Couple of Carriage returns to text file

I have a directory of over a hundred text files that I'm getting ready to merge with the CAT command. However there is only one space after each file; this makes the output look crowded. I would like to add two, possibly even four carriage returns at the end of each text file to make the final... (2 Replies)
Discussion started by: tg3793
2 Replies

9. Shell Programming and Scripting

sed returns different results while substitution on a pipe delimited file

Hi, Need help with a sed command that I am using to substitute 3 positions of a pipe delimited file. i am getting different results while substituting the same position of two different files with the same value. Please see details below: $ cat chk2 ... (3 Replies)
Discussion started by: vmenon
3 Replies

10. Shell Programming and Scripting

TR not removing carriage returns

I have a CSV with carriage returns in place of newlines. I am trying to use tr to remove them, but it isn't working. Academic year,Term,Course name,Period,Last name,Nickname 2012-2013,First Semester,English 12,4th Period,Arnold,Adam 2012-2013,First Semester,English 12,4th Period,Adams,Jim... (1 Reply)
Discussion started by: nextyoyoma
1 Replies

LEARN ABOUT SUSE

finance::quote::lerevenu

Finance::Quote::LeRevenu(3)				User Contributed Perl Documentation			       Finance::Quote::LeRevenu(3)

NAME

       Finance::Quote::LeRevenu Obtain quotes from http://bourse.lerevenu.com.

SYNOPSIS

	   use Finance::Quote;

	   $q = Finance::Quote->new;

	   %info = Finance::Quote->fetch("LeRevenu","FR0000031122");  # Only query LeRevenu
	   %info = Finance::Quote->fetch("france","ml"); # Failover to other sources OK.

DESCRIPTION

       This module fetches information from the "Paris Stock Exchange", http://bourse.lerevenu.com. All stocks are available.

       This module is loaded by default on a Finance::Quote object. It's also possible to load it explicity by placing "LeRevenu" in the argument
       list to Finance::Quote->new().

       This module provides both the "lerevenu" and "france" fetch methods.  Please use the "france" fetch method if you wish to have failover
       with future sources for French stocks. Using the "lerevenur" method will guarantee that your information only comes from the Paris Stock
       Exchange.

       Information obtained by this module may be covered by http://bourse.lerevenu.com terms and conditions See http://bourse.lerevenu.com for
       details.

LABELS RETURNED

       The following labels may be returned by Finance::Quote::LeRevenu : name, last, date, p_change, open, high, low, close, volume, currency,
       method, exchange.

SEE ALSO

       Le Revenu, http://bourse.lerevenu.com

perl v5.12.1							    2010-07-05					       Finance::Quote::LeRevenu(3)
All times are GMT -4. The time now is 09:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy