Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to mege with quotes in single line?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to mege with quotes in single line?
# 1  
Old 11-05-2013
How to mege with quotes in single line?
Hi

I have input vi file as below

Code:
a000000
b000000
c000000
d000000

Need output as below

Code:
'a000000','b000000','c000000','d000000'

Please let us know how to do it
Last edited by Scrutinizer; 11-05-2013 at 07:32 PM.. Reason: code tags
# 2  
Old 11-05-2013
try:
Code:
awk '$1=$1 {print "\x27" $0 "\x27"}' RS= OFS="','" file

RS= (no record separator)
OFS="','" (output field separator)
$1=$1 (merge fields with defined OFS)
\x27 (hex tick mark)
# 3  
Old 11-05-2013
hi
I'm seeing below error message.

Code:
bash-3.00$ awk '$1=$1 {print "\x27" $0 "\x27"}' RS= OFS="','" testy1
awk: syntax error near line 1
awk: bailing out near line 1


testy1 is the vi file it has following lines

Code:
p422989
p443149
p445676
p452377
p454398
p455775
p457716
p458345
p459716
p465880
p466427
p466428
p467681

# 4  
Old 11-05-2013
Try:
Code:
awk '{s=s (s?OFS:x) q $0 q} END{print s}' q=\' OFS=, file


----
On Solaris use /usr/xpg4/bin/awk rather than awk
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to add line breaks to perl command with large text in single quotes?

Below code extracts multiple field values from XML into array and prints all in one line. perl -nle '@r=/(?: jndiName| authDataAlias| value| minConnections| maxConnections| connectionTimeout| name)="(+)/g and print join ",",$ENV{tIPnSCOPE},$ENV{pr ovider},$ENV{impClassName},@r' server.xml ... (4 Replies)
Discussion started by: kchinnam
4 Replies

2. Shell Programming and Scripting

Issue with Single Quotes and Double Quotes for prompt PS1

Hi, Trying to change the prompt. I have the following code. export PS1=' <${USER}@`hostname -s`>$ ' The hostname is not displayed <abc@`hostname -s`>$ uname -a AIX xyz 1 6 00F736154C00 <adcwl4h@`hostname -s`>$ If I use double quotes, then the hostname is printed properly but... (3 Replies)
Discussion started by: bobbygsk
3 Replies

3. Shell Programming and Scripting

Having a terrible problem with quotes/single quotes!

Hello. I'm trying to write a bash script that uses GNU screen and have hit a brick wall that has cost me many hours... (I'm sure it has something to do with quoting/globbing, which is why I post it here) I can make a script that does the following just fine: test.sh: #!/bin/bash # make... (2 Replies)
Discussion started by: jondecker76
2 Replies

4. Shell Programming and Scripting

Replace single quote with two single quotes in perl

Hi I want to replace single quote with two single quotes in a perl string. If the string is <It's Simpson's book> It should become <It''s Simpson''s book> (3 Replies)
Discussion started by: DushyantG
3 Replies

5. UNIX for Dummies Questions & Answers

grep single quotes or double quotes

Unix superusers, I am new to unix but would like to learn more about grep. I am very familiar with regular expressions as i have used them for searching text files in windows based text editors. Since I am not very familiar with Unix, I dont understand when one should use GREP with the... (2 Replies)
Discussion started by: george_vandelet
2 Replies

6. Shell Programming and Scripting

Single quotes and double quotes

Hi guys, I have a sed line in double quotes which works fine, but I want it to be in single quotes here is the sed line sed "/abc_def/s/\'.*\'/\'\${abc_def}\'/" can some one give the equivalent to the above script in single quotes Thanks a ton (5 Replies)
Discussion started by: sol_nov
5 Replies

7. Shell Programming and Scripting

Double quotes or single quotes when using ssh?

I'm not very familiar with the ssh command. When I tried to set a variable and then echo its value on a remote machine via ssh, I found a problem. For example, $ ITSME=itsme $ ssh xxx.xxxx.xxx.xxx "ITSME=itsyou; echo $ITSME" itsme $ ssh xxx.xxxx.xxx.xxx 'ITSME=itsyou; echo $ITSME' itsyou $... (3 Replies)
Discussion started by: password636
3 Replies

8. Programming

Checking Single Quotes in C

Hi ! Can anyone please tell me how can I check if a character is single quotes in C ? Thanks, Jane A (3 Replies)
Discussion started by: janemary.a
3 Replies

9. UNIX for Dummies Questions & Answers

im stuck! 'single quotes'

Hi all... This is probably the simplest question but its driving me round the bend :-( does anyone know how to store a single quote in a variable. Im using cygwin bash for example single_qoute = " ' " echo single_quote dosnt work :-( it is absolutely baffling me! The reason why... (4 Replies)
Discussion started by: satnamx
4 Replies

10. Shell Programming and Scripting

Filename containing Single Quotes

Hi , I am passing a variable site_name from a shellscript to an SQL script and then I want to spool an sql query on to my Unix box and generate a CSV file. Everything works fine but I have to give quotes to the variable '&&site_name' in spool statement ..if i remove the quotes it generates an LST... (6 Replies)
Discussion started by: phani
6 Replies
Login or Register to Ask a Question