Hello, ok here's as short and succinct a sample as I can create.
use Text::CSV;
use CGI;
my($row) = "search/¿Cuales son las partes de una cadena de conexión??s
+cope|ids_jdbc_011.htm|0|1|1|0";
my $csv = Text::CSV->new ({ binary => 1, sep_char => "|" });
my $q = new CGI;
# print the HTML header and start html
print $q->header;
print $q->start_html;
# first, print $row as is
print $q->p("ROW: $row");
# next, parse with $csv
$csv->parse($row);
my @els = $csv->fields;
# print the first field
# this displays the black diamond ? symbol for ¿ and ó
print $q->p("CSV Parse, field 0:",$els[0]);
# split instead
my(@splits) = split('\|',$row);
# print the first element in @splits.
# As noted, this one displays properly in the browser.
print $q->p("split 0:", $splits[0]);
print $q->end_html;
exit;
thanks
======================
UMM, update, when I actually ran the above in my http server I got the opposite results, but with weird errors.
ROW: search/¿Cuales son las partes de una cadena de conexión??scope|
+ids_jdbc_011.htm|0|1|1|0
CSV Parse, field 0: search/¿Cuales son las partes de una cadena de con
+exión??scope
split 0: search/¿Cuales son las partes de una cadena de conexión??sc
+ope
Paint me confused.
In the real script, $row is coming from a @sorted_array from an SQL query. This is getting confusing so maybe I should withdraw my question.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.