Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replace newline with comma and append quotes
Top Forums UNIX for Beginners Questions & Answers Replace newline with comma and append quotes Post 303034250 by RavinderSingh13 on Monday 22nd of April 2019 10:07:36 PM
Old 04-22-2019
Quote:
Originally Posted by Rtk
Hi,
I have below requirement.
Apple
Orange
Banana
Required O/p in bash
'Apple,Orange,Banana'
Can you please help.
Hello Rtk,

Could you please try following.
Code:
awk 'BEGIN{s1="'";OFS=","} {val=val?val OFS $0:$0} END{print s1 val s1}'  Input_file

Thanks,
R. Singh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace comma with newline

Hi, for some reason I cant seem to figure this out. I have a file which looks something like this word word word word word,word,word word word word,word,word,word,word word word Basically I want this whole thing to be a list with 1 word on each line like this... word word word... (1 Reply)
Discussion started by: eltinator
1 Replies

2. Shell Programming and Scripting

To Replace comma with Pipe inside double quotes

Hi, I have a requirement to replace the comma's inside the double quotes. The comma's inside the double quotes will get changed dynamically. Input Record: "Washington, DC,Prabhu,aju",New York Output Record: "Washington| DC|Prabhu|aju",New York I tried with the below command but it... (3 Replies)
Discussion started by: prabhutkl
3 Replies

3. Shell Programming and Scripting

Replace newline with comma.

I have output from a file like this: 15,01,11,14:06 235 I would like to change this to: 15,01,11,14:06,235 Removing newline and change to "," I now this can be done with tr cat OUT | tr '\n' ','' My problem is that tr is not implemented in this shell. sed is, show it should be... (7 Replies)
Discussion started by: Jotne
7 Replies

4. Shell Programming and Scripting

shell script - to append single quotes and comma

file1 ---- 34556745 32678343 31576776 31455566 21356666 I want to assign the record values to a variable in the below format, so that I can use output in .sql file for querying in database. ('34556745', '32678343', '31576776', '31455566', '21356666') ----------- below is the... (11 Replies)
Discussion started by: rajivrsk
11 Replies

5. Shell Programming and Scripting

Replace newline character between a double quotes to a space

Hi Guys, I have a file with content as below aj.txt "Iam allfine" abcdef abcd "all is not well" What I'm trying to say is my data has some new line characters in between quoted text. I must get ride of the newline character that comes in between the quoted text. output must be:... (8 Replies)
Discussion started by: ajahuja
8 Replies

6. Shell Programming and Scripting

Replace comma delimiter by newline

The input file is as below AR,age,marks,roll,section,evin,25,80,456,A,atch,23,56,789,B,eena,24 ,78H245,C,Ps,ot,ecessary,hat,ame comes first then age and rest AR AZ,kevin,25,80,456,A,Satch,23,56,789,Satch,23,56,789,B,Meena,24,78,H245,C,AZ ................ ................ I am writting... (8 Replies)
Discussion started by: millan
8 Replies

7. Shell Programming and Scripting

How to replace NewLine with comma using sed?

Hi , I have a huge file with following records and I want to replace the last comma with ',NULL'. I try using SED but could not create a correct script . In my opinion I need a script which can convert ,/n with ,NULL/n 1,CHANGE_MEMBER,2010-12-28 00:05:00, 2,CHANGE_MEMBER,2012-09-02... (8 Replies)
Discussion started by: Ajaypal
8 Replies

8. Shell Programming and Scripting

Command to replace newline with comma

Hi Experts, I need an urgent help in replacing newline characters in my single column file by a comma. I am using following command for this purpose: sed -n -e 'H;${x;s/\n/,/g;s/^,//;p;}' parameter.rtf | rev | cut -c 4- | revMy input file has: TABLE_1 TABLE_2 TABLE_3 What I need:... (11 Replies)
Discussion started by: neerndg123
11 Replies

9. Programming

Replace comma which is not inside brackets,quotes or paranthesis

Hi All, I want to replace the commas which are not inside parenthesis,quotes if input is abc,,lm,(no,pq,rs),{tu,vw,xy},zs,"as,as,fr",'ab,cd,ef' output should be abc lm (no,pq,rs) {tu,vw,xy} zs "as,as,fr" 'ab,cd,ef' I tried this str.replaceAll("\\(.*?\\)|(,)", " "); say my string... (3 Replies)
Discussion started by: preethy
3 Replies

10. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ... (3 Replies)
Discussion started by: as7951
3 Replies

LEARN ABOUT OSX

submitdiaginfo

SubmitDiagInfo(8)					    BSD System Manager's Manual 					 SubmitDiagInfo(8)

NAME

     SubmitDiagInfo -- sends diagnostic information to Apple

SYNOPSIS

     SubmitDiagInfo

DESCRIPTION

     SubmitDiagInfo is a system process which runs periodically.  If the user has opted-in for automatic reporting of diagnostic and usage infor-
     mation, then SubmitDiagInfo collects and sends to Apple any recent diagnostic information which has not yet been sent to Apple.
     SubmitDiagInfo also cleans up any diagnostic and usage information which was created more than one month ago and is no longer needed.

     Sending diagnostic and usage reports to Apple helps us improve the quality and performance of our products and services.  It helps Apple
     identify common usage trends and issues that enable us to allocate our resources efficiently, and it helps us provide better support services
     to you and other customers.  All of the diagnostic and usage information is collected anonymously from your computer in a way that does not
     personally identify you.  Reports may include the following information:

     -	 Details about application or system crashes, freezes, or kernel panics.
     -	 Information about events on your computer (e.g. whether a certain function, such as waking your computer was successful or not).
     -	 Usage information (e.g. data about how Apple and third party software, hardware and services are being used).

     Automatic reporting of diagnostic information is off by default and no information is sent to Apple unless a user has opted-in to automatic
     collection of diagnostic information.  A user is offered the opportunity to opt-in for automatic collection of additional diagnostic and
     usage information after the user has manually sent a crash, hang or panic report to Apple.  Users may at any time opt in or out of automatic
     reporting in the Security & Privacy pane of the System Preferences application under the "Privacy" tab.

     All diagnostic and usage information which is eligible for automatic reporting is visible in the Console application under the "DIAGNOSTIC
     AND USAGE INFORMATION" heading in the application's sidebar.  (The information appears here even if a user has not yet opted-in for automatic
     reporting.)  For security purposes, some system diagnostic information will only be visible to admin users and will only be submitted when an
     admin user is logged in.

     Users who need technical support should use http://www.apple.com/support or other authorized support channels.  Developers who are ADC mem-
     bers should submit bug reports using http://bugreporter.apple.com in order to allow for two way communication between Apple and the bug
     reporter.

SEE ALSO

     ReportCrash(8)

Mac OS								   June 2, 2019 							    Mac OS
All times are GMT -4. The time now is 08:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy