Split process

santhosh_89 has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks,

I have a scalar variable,I need to be splited based on the comma(,).if the comma is present with in double or single quote.The split or regular expression should not consider it.

Input:
my $a="a,b,\"c,d\"";
There is a comma with in c and d.The code should not be considered that comma(,),The output should be as following. output of Dumper:

         $VAR1=[
                a,
                b,
                \"c,d\"
                ]
[download]

Comment on Split process Select or Download Code

Replies are listed 'Best First'.
Re: Split process by moritz (Cardinal) on Aug 04, 2009 at 06:22 UTC
You should use a module like Text::CSV for that (and set the delimiter to the comma).	[reply]
Re: Split process by Skeeve (Parson) on Aug 04, 2009 at 06:31 UTC
I think, split can't handle that easily. If you can't (everyone can) go the suggested route of using a propper module, please bear in mind that a quote inside quotes might appear and so has to be escaped somehow. So you have to find out how this escaping is done. Some application double them (`"this is a 24"" monitor"`), some might use backslashes (`'can\'t open file'`) or even go the "shell way" (`'this ain'\''t cool'`). `s$$([},&%#}/&/]+}%&{});#$&&s&&$^X.($'^"%]=\&(\|?{%` `+`.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e	[reply] [d/l] [select]