Hi,

Sorry guys, for posting my issue over here. I tried for sometimes but still i cant find my way to create a new thread. Please clarify my below issue.

I am writing a perl script to compare two columns of a spreadsheet and export the difference to a new CSV file. Everything working fine but for a particular string called "%ph_digits" on the excel is printed on the CSV file as "353ach_digits". I am litterally confused what went wrong. But the other string like "%Name_Number" is printed correctly in the CSV file.

Below is just the snippet of my code where i am extracting data from the excel sheet and loading into an array. Later i move the array to a CSV file.

Add to this,i am also facing another issue. If excel file contains any arabic language like "специал. функции" then the value exported into the CSV is like "???????. ???????"

Please reply and help me on this. 

            $my_row = ($Sheet->Cells($row,$eur_column)->{'Value'});
            $my_row =~ s/(^\s+|\s+$)//g;
            $my_column = ($Sheet->Cells($row,$gom_column)->{'Value'});
            $my_column =~ s/(^\s+|\s+$)//g;
            $feedback_value = ($Sheet->Cells($row,$feedback_ID)->{'Val
+ue'});
            $feedback_value =~ s/(^\s+|\s+$)//g;
            
            if ($my_row ne $my_column)
            {
                printf " %s At ($row, $col) the row is %s and the colu
+mn is %s for EUR & NAM \n", $feedback_value, $my_row,$my_column;
                push @gm_out, [ $feedback_value, $my_row,$my_column,0 
+];
            }

[download]

In reply to %p issue on perl script by Sathish

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.