Removal of comma(,) present inbetween double quotes(" ")

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Removal of comma(,) present inbetween double quotes(" ")

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
To Replace comma with Pipe inside double quotes	prabhutkl	Shell Programming and Scripting	3	04-26-2009 11:24 PM
Samba (SMB) client fails: "Called name not present"	big123456	Windows & DOS: Issues & Discussions	0	11-26-2008 01:49 PM
sed removing comma inside double quotes	joanneho	Shell Programming and Scripting	2	06-30-2008 01:13 AM
comparing scalars contaning "DOUBLE QUOTES" as data	rssrik	Shell Programming and Scripting	5	04-20-2008 10:25 AM
Eth err: "3c501 device eth0 does not seem to be present"	praveen_b744	UNIX for Advanced & Expert Users	2	12-17-2007 01:22 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

07-17-2009

vsairam

Registered User

Join Date: Jul 2009

Posts: 15

Removal of comma(,) present inbetween double quotes(" ")

Hi Experts,

I have a file with some of the records contain double quotes. If I found a double quote(") in any particular record , I need to look for the next double quote in that particular record and in between these quotes, if any comma(,) is there I need to replace with Tilde (~) in the same file.

For Example:

Code:

123,abcd,FirstRecord
345,"abc,cde",SecondRecord
567,ghij,ThirdRecord
789,"klmn,opq",FourthRecord"
908,"zwec,ctu,kyz",FifthRecord

Output should be like this:

Code:

123,abcd,FirstRecord
345,"abc~cde",SecondRecord
567,ghij,ThirdRecord
789,"klmn~opq",FourthRecord
908,"zwec~ctu~kyz",FifthRecord

Can you please help in this scenarios in shell scripting

Last edited by Yogesh Sawant; 07-17-2009 at 06:56 AM.. Reason: added code tags

Bookmarks

« Getting value from oracle to unix shell | ftp, archive, email and delete from shell script »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 06:30 AM.