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 303034296 by MadeInGermany on Tuesday 23rd of April 2019 01:28:48 AM
Old 04-23-2019
Does "'" within ' ' work correctly?
I think it must be "'\''".
The following defines it outside the ' '
Code:
awk '{val=(val sep $0); sep=","} END {print (q val q)}' q="'"  Input_file

BTW val=val?val OFS $0:$0 might behave wrongly if the first lines are empty or zero.
Last edited by MadeInGermany; 04-23-2019 at 05:03 AM..
 

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 NETBSD

akbd

AKBD(4) 						   BSD Kernel Interfaces Manual 						   AKBD(4)

NAME

     akbd -- Apple Desktop Bus keyboard driver for wscons

SYNOPSIS

     akbd* at obio?
     wskbd* at akbd? console ?

     options ALTXBUTTONS
     options CAPS_IS_CONTROL
     options FORCE_FUNCTION_KEYS

DESCRIPTION

     This driver provides the wscons(4) driver with support for Apple Desktop Bus keyboards.

     To work around the limited number of buttons found on most ADB mice, one can map key sequences to trigger mouse button events.  To map
     Option+1, Option+2, Option+3 to mouse buttons 1, 2, and 3 respectively, add the following line to your kernel configuration file:

     options ALTXBUTTONS

     On macppc systems it is possible to tweak the keyboard driver to treat the caps lock key on an ADB keyboard as a control key.  This requires
     special remapping because of ADB's strange emulation of a mechanically-locked key.  To enable this code add the following line to your kernel
     configuration file:

     options CAPS_IS_CONTROL

     On macppc PowerBooks, several function keys double as "hot keys" (brightness, volume, eject) when the Fn modifier is held down.  Mac OS X
     likes to reprogram the keyboard controller to send hot key events when Fn is not held down and send function key events when it is.  To
     transform the non-keyboard "button" events back into function key events, place the following line in your kernel configuration file:

     options FORCE_FUNCTION_KEYS

SUPPORTED HARDWARE

     NetBSD is known to support the following ADB keyboards:

	   o   On-board keyboards on PowerBook models

	   o   Apple Standard Keyboard

	   o   Apple Keyboard II

	   o   Apple Extended Keyboard

	   o   Apple Extended Keyboard II

	   o   Apple Adjustable Keyboard

	   o   Most third-party ADB keyboards are supported

SEE ALSO

     adb(4), wscons(4), wskbd(4), wsconsctl(8)

BUGS

     The number pad on extended keyboards does not send out the proper key codes for many applications.

     The LEDs on extended keyboards are not functional under NetBSD.

BSD
								September 21, 2003							       BSD
All times are GMT -4. The time now is 06:21 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy