How to use quotewords for CSV text, but still make it not ignore the trailing empty fields?

[mmasroorali]

Dear All,
I have some autogenrated CSV text where a typical line looks like this,

"A", "B, C and D", "E",,,,,

See the empty fields at the end? Now when I use quotewords, the
trailing null fields are stripped from the result. So, I get only three
fields. But I want to get the last columns as empty fields. In case of
split, I could use the limit as the third parameter. Could any kind
soul please tell me what I could do in this situation?

Regards,

 

[A. Sinan Unur]

(e-mail address removed) wrote in

Dear All,
I have some autogenrated CSV text where a typical line looks like
this,

"A", "B, C and D", "E",,,,,

See the empty fields at the end? Now when I use quotewords, the
trailing null fields are stripped from the result.

Please read the posting guidelines for this group. Please always post a
minimal example that exhibits the problem you want to solve.

So, I get only three fields.

How so?

use strict;
use warnings;

use Data:umper;

use Text:arseWords;

my @fields = quotewords(',\s*', 0, q{"A", "B, C and D", "E",,,,,});
print Dumper \@fields;

__END__

C:\Home> c.pl

$VAR1 = [
'A',
'B, C and D',
'E',
'',
'',
'',
'',
undef
];

I don't know why the last field is undef rather than ''.

Sinan

 

[Damian James]

Dear All,
I have some autogenrated CSV text where a typical line looks like this,

"A", "B, C and D", "E",,,,,

See the empty fields at the end? Now when I use quotewords, the
trailing null fields are stripped from the result. So, I get only three
fields. But I want to get the last columns as empty fields. In case of
split, I could use the limit as the third parameter. Could any kind
soul please tell me what I could do in this situation?

Quotewords? You don't mean as in 'qw'? Don't see how that applies.

Use Text::CSV. Really, there are more issues that dealing with additional
commas. You don't want to revisit them all.

--damian