Solved

How can I replace this string in sed?

Posted on 2013-05-23
2
329 Views
Last Modified: 2013-05-24
Hi,

I have a large csv file with lines with strings like below
How can I convert this in sed for all lines?
The values can be anything, it's just that the list is in [u'xxx']

"[u'Kitts Corner', u'Jovita']", abc, "[u'AAA', u'BBB', u'CCC']"
to
"Kitts Corner,Jovita", abc, "AAA,BBB,CCC"

Thanks
Jamie
0
Comment
Question by:jamie_lynn
2 Comments
 
LVL 84

Accepted Solution

by:
ozo earned 500 total points
ID: 39193011
sed -e "s/u\{0,1\}'//g" -e "s/[][]//g" <<END
 "[u'Kitts Corner', u'Jovita']", abc, "[u'AAA', u'BBB', u'CCC']"
END
0
 

Author Closing Comment

by:jamie_lynn
ID: 39195107
Works great!
Thanks!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This tech tip describes how to install the Solaris Operating System from a tape backup that was created using the Solaris flash archive utility. I have used this procedure on the Solaris 8 and 9 OS, and it shoudl also work well on the Solaris 10 rel…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question