<br>This solution worked...<br><br> s := stringReplace(s,chr(148),'"',[rfReplaceAll, rfIgnoreCase]);<br> s := stringReplace(s,chr(147),'"',[rfReplaceAll, rfIgnoreCase]);<br> s := stringReplace(s,chr(150),'--',[rfReplaceAll, rfIgnoreCase]);<br>
s := stringReplace(s,chr(146),'''',[rfReplaceAll, rfIgnoreCase]); <br><br>However this car is also giving me issues: é <br>There is not "equivalent"... only e...<br>Or is that é and alt 130 (é) different?<br>
<br>But this must be a problem that's happened a lot before? Not so?<br><br>
<br><br><div class="gmail_quote">On Sun, Feb 22, 2009 at 5:20 PM, Reenen Laurie <span dir="ltr"><<a href="mailto:rlaurie@gmail.com">rlaurie@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Ermmm...<br><br>Seems like google has something to "clean" those chars from it. When I tried to post it, I had the weird character in there...<div><div></div><div class="Wj3C7c"><br><br><div class="gmail_quote">
On Sun, Feb 22, 2009 at 5:19 PM, Reenen Laurie <span dir="ltr"><<a href="mailto:rlaurie@gmail.com" target="_blank">rlaurie@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>Luca said:<br>You have to either convert the file to utf8 before opening it or convert<br>
it while you read it.<br><br></div>How do I convert it? What I've tried is: <br>* Open the badly formatted file in the Lazarus IDE, then copied the "funny" chars into the following code:<br><span style="font-family: courier new,monospace;">* s := stringReplace(s,'"','""',[rfReplaceAll, rfIgnoreCase]);</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">* s := stringReplace(s,'"','""',[rfReplaceAll, rfIgnoreCase]); </span><br><br>But that also doesn't work... <br><br>Sigh...<br><br>Regards,<br>
<font color="#888888">
-Reenen</font><div><div></div><div><br><br><br><div class="gmail_quote">On Sun, Feb 22, 2009 at 4:36 PM, Luca Olivetti <span dir="ltr"><<a href="mailto:luca@wetron.es" target="_blank">luca@wetron.es</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
En/na Reenen Laurie ha escrit:<br>
<div>><br>
> Hi all,<br>
><br>
> I am at the end of my patience, and I have no clue what to do, and this<br>
> project needed to have been done a week or so back.<br>
><br>
> When I execute attached program (*very* simple). And open file<br>
> "example.csv" then my showmessage command doesn't display anything.<br>
><br>
> I am unsure if there is anything in the string, though I think it is.<br>
><br>
> Please help! How can I get that funny chars to display... even if I have<br>
> to somehow replace them with an ascii counterpart.<br>
<br>
</div>The LCL only works with utf8, while your file appears to be cp1250.<br>
You have to either convert the file to utf8 before opening it or convert<br>
it while you read it.<br>
BTW, under linux I see the funny characters, though they're not what<br>
they should be. I don't know it if is because I'm trying with a snapshot<br>
of 0.9.26.1 or because the linux interface is more tolerant with<br>
malformed strings than the windows one.<br>
<br>
Bye<br>
<font color="#888888">--<br>
Luca<br>
_______________________________________________<br>
Lazarus mailing list<br>
<a href="mailto:Lazarus@lazarus.freepascal.org" target="_blank">Lazarus@lazarus.freepascal.org</a><br>
<a href="http://www.lazarus.freepascal.org/mailman/listinfo/lazarus" target="_blank">http://www.lazarus.freepascal.org/mailman/listinfo/lazarus</a><br>
</font></blockquote></div><br><br clear="all"><br></div></div><div><div></div><div>-- <br>o__<br>,_.>/ _<br>(_)_\(_)_______<br>...speed is good<br>_______________<br>I believe five out of four people have a problem with fractions.<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>o__<br>,_.>/ _<br>(_)_\(_)_______<br>...speed is good<br>_______________<br>I believe five out of four people have a problem with fractions.<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>o__<br>,_.>/ _<br>(_)_\(_)_______<br>...speed is good<br>_______________<br>I believe five out of four people have a problem with fractions.<br>