Hi,
I have a string of text with values enclosed by double quotes in each line of the text file.
Using perl, how do i remove the double quotes but without doing any other formatting on the line.
My example text is:
"value1","value2","value3"
and i want it to look like:
value1,value2,value3,value
Many thanks in advance.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thanks for that. I'm really new to perl and i'm only beginning to get my head around it.
How do i use your example within a script?
I've got this code and i would like to have the results of the stripping held within my recline
my $csvfile = "example.csv"
open(DAT, $csvfile) || die("count not open file!");
my @recline= <DAT>;
close(DAT);
The code you're looking for is:
map { s/\"//g; } @recline;
Be advised that this will only do what you want for strings that do not contain escaped quotes.
If you the following string "He said, \"Hi\"", an ideal quote stripping routine would produce: He said, "Hi"
But the code above will produce: He said, Hi
If you're happy with that result, use the provided code.
splain
/usr/bin/splain: Reading from STDIN
Global symbol "@recline" requires explicit package name at test.pl line 10
Global symbol "@recline" requires explicit package name at test.pl line 10 (#1)
(F) You've said "use strict" or "use strict vars", which indicates
that all variables must either be lexically scoped (using "my" or "state"),
declared beforehand using "our", or explicitly qualified to say
which package the global variable is in (using "::").
perldoc perlstyle
o Avoid using "grep()" (or "map()") or `backticks` in a void context,
that is, when you just throw away their return values. Those
functions all have return values, so use them. Otherwise use a
"foreach()" loop or the "system()" function instead.
Business Accounts
Answer for Membership
by: ghostdog74Posted on 2009-08-09 at 18:48:00ID: 25056737
this is simple task and you should have tried to give it a shot.
Select allOpen in new window