Hi Monks ,
Am in a bit of confusion here with no clue on what is causing this exception. I have written a perl script which extracts rows of data from SharePoint list using SOAP::Lite Module.
The extraction works properly , but in certain scenarios the special character symbols are converted when i open the CSV file which is created by Perl script.
Part of Code snippet which extract the mentioned columns and write it into a CSV file. I have already parsing them as UTF-8
my $element_rowlimit = name( 'rowLimit' => 10000 );
#print $soap->serializer->envelope( 'method' => 'GetListItems', $eleme
+nt_listname, $element_query, $element_rowlimit );
my $som = $soap->GetListItems( $element_listname, $element_query, $ele
+ment_rowlimit );
my @results = $som->dataof('//GetListItemsResult/listitems/data/row');
my $oc = Text::CSV->new({sep_char => ',', eol => $/ })
or die Text::CSV->error_diag();
open my $of, '>', 'Load_Data.csv' or die $!;
binmode $of, ':utf8';
chomp @results;
foreach my $data (@results) {
my $item = $data->attr;
chomp $item;
$oc->print($of,[@$item{qw( ows_Job_x0020_ID ows_Justific
+ation )}]);
}
close $of;
Lets say the Value of Justification column in Sharepoint is as : "RMS Roughness (Rq) is ~3.7Å for both wafers."
But, when extracted by perl , the comment is changed to following : "RMS Roughness (Rq) is ~3.7Ã for both wafers."