Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replace double quotes with a single quote within a double quoted string
Top Forums Shell Programming and Scripting Replace double quotes with a single quote within a double quoted string Post 302900205 by pchang on Monday 5th of May 2014 11:56:35 AM
Old 05-05-2014
Quote:
Originally Posted by Subbeh
Try this instead:
Code:
sed "s/\([^,]\)\"\([^,]\)/\1'\2/g" file

WOW!!! - thank you.

Your code works great!!! The only thing is that it's only substituting the first occurence of a double quote, not all occurences within the string. See bold/underline data below. Could you enhance your code to replace all occurences of double quotes within the text string?

Input Data:
Code:
0000005335,"IBD","601725","6017257002503849","0430","153854","007907","0079070
00000","E0107725","2995 BL.DAGENAIS "H"   LAVAL        QCCA","0200","","","WD","
CH","","4001857090","","124","124",,60.00,60.00,60.00,0.00,0.45,60.45,0.037500,"
APP","00","EXC","5"

Output Data:
Code:
0000005335,"IBD","601725","6017257002503849","0430","153854","007907","0079070
00000","E0107725","2995 BL.DAGENAIS 'H"   LAVAL        QCCA","0200","","","WD","
CH","","4001857090","","124","124",,60.00,60.00,60.00,0.00,0.45,60.45,0.037500,"
APP","00","EXC","5"

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

single or double quote in SED

i m trying the following command but its not working: sed 's/find/\'replace\'/g' myFile but the sed enters into new line # sed 's/find/re\'place/g' myFile > I havn't any idea how to put single quote in my replace string. Your early help woud be appreciated. Thanx (2 Replies)
Discussion started by: asami
2 Replies

2. 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

3. Shell Programming and Scripting

Regex in grep to match all lines ending with a double quote (") OR a single quote (')

Hi, I've been trying to write a regex to use in egrep (in a shell script) that'll fetch the names of all the files that match a particular pattern. I expect to match the following line in a file: Name = "abc" The regex I'm using to match the same is: egrep -l '(^) *= *" ** *"$' /PATH_TO_SEARCH... (6 Replies)
Discussion started by: NanJ
6 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. Shell Programming and Scripting

Replace double double quotes using AWK/SED

Hi, I have data as "01/22/97-"aaaaaaaaaaaaaaaaa""aaa""aabbbbbbbbcccccc""zbcd""dddddddddeeeeeeeeefffffff" I want to remove only the Consequitive double quotes and not the one which occurs single. My O/P must be ... (2 Replies)
Discussion started by: Bhuvaneswari
2 Replies

6. 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

7. Shell Programming and Scripting

sed command to replace string that contain blackslash,double quotes

Hi All, I have been trying to replace a string using the sed command string value contain blackslash and double quotes. I am not a expert writer of unix script but do try not to ask question. I have almost given up. Hope you all can give me some suggestion I want to replace a place string... (6 Replies)
Discussion started by: thanush9sep
6 Replies

8. Shell Programming and Scripting

Replace Double quotes within double quotes in a column with space while loading a CSV file

Hi All, I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes. Sample Data : "221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Discussion started by: mlavanya
6 Replies

9. Shell Programming and Scripting

Replacing all but the first and last double quote in a line with a single quote with awk

From: 1,2,3,4,5,This is a test 6,7,8,9,0,"This, is a test" 1,9,2,8,3,"This is a ""test""" 4,7,3,1,8,"""" To: 1,2,3,4,5,This is a test 6,7,8,9,0,"This; is a test" 1,9,2,8,3,"This is a ''test''" 4,7,3,1,8,"''"Is there an easy syntax I'm overlooking? There will always be an odd number... (5 Replies)
Discussion started by: Michael Stora
5 Replies

10. Shell Programming and Scripting

Replace double quotes inside the string data for all the columns

Please use code tags Hi, I have input data is below format and n of column in the multiple flat files. the string data has any double quotes(") values replaced to double double quotes for all the columns{""). Also, my input flat file each column string data has carriage of new line too.... (14 Replies)
Discussion started by: SSrini
14 Replies

LEARN ABOUT CENTOS

lldptool-app

lldptool(8)							       Linux							       lldptool(8)

NAME

       APP - Show / manipulate APP TLV configuration

SYNOPSIS

       lldptool -t -i ethx -V APP [-c app]

       lldptool -T -i ethx -V APP [-d] app=prio,sel,pid

DESCRIPTION

       The  APP  TLV  is an informational TLV and will advertise the current configured application table. If the peer APP TLV and a local APP TLV
       match the same selector and protocol field the local parameter is used.

ARGUMENTS

       app    Configures a local application data field using the three parameters: priority (prio), selector (sel), and protocol  (pid).  The	-d
	      option can be provided to remove an entry which matches the three parameters.

Theory of Operations
       The  APP  TLV is an informational TLV for most end stations. It is not expected that setting APP data should be required. Peer data will be
       processed and added to the application data table by default assuming there does not already exist a local entry with matching selector and
       priority fields.

       By adding APP data to the application table it is available for applications, eg iscsid, to query. Applications query for a specific proto-
       col and selector and may use this data to map traffic to the corresponding traffic class.

EXAMPLE &; USAGE
       Configure ISCSI application for priority 4 on eth2
	      lldptool -T -i eth2 -V APP app=4,2,3260

       Configure FCoE application for priority 3 on eth2
	      lldptool -T -i eth2 -V APP app=3,1,35078

       Remove FCoE application for priority 3 on eth2
	      lldptool -T -i eth2 -V APP -d app=3,1,35078

       Display locally configured application table on eth2
	      lldptool -t -i eth2 -V APP -c app

       Display last transmitted APP TLV on eth2
	      lldptool -t -i eth2 -V APP

SOURCE

       o      IEEE 802.1Qaz (http://www.ieee802.org/1/pages/dcbridges.html)

SEE ALSO

       lldptool(8), lldpad(8)

AUTHOR

       John Fastabend

open-lldp							   February 2010						       lldptool(8)
All times are GMT -4. The time now is 02:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy