[Excel, VB6] Encode text before sending to Linux server

[JoTak]

Hi,
I have a big problem when trying to send text from an Excel application
running on Windows, to a Linux server. On the server some special characters
like "€" or carriage returns are not properly retieved from the Windows
client.
So I need to know if there is a function that can encode text to do such
ASCII network transfers.
Thanks in advance!
J.

 

[Steve Rindsberg]

Hi,
I have a big problem when trying to send text from an Excel application
running on Windows, to a Linux server. On the server some special characters
like "€" or carriage returns are not properly retieved from the Windows
client.
So I need to know if there is a function that can encode text to do such
ASCII network transfers.
Thanks in advance!

How are you sending the text? If by FTP, try binary rather than ASCII
transfer.

 

[JoTak]

How are you sending the text? If by FTP, try binary rather than ASCII
transfer.

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Not it's not FTP - sorry I should have been more accurate. I directly send
XML streams using POST method to a http server.
After investigation, it appears that my problem isn't related to linux, but
it's all on the client side: the data is corrupted when it's added to the DOM
object within VB code.
Does someone know how to prevent it?
I'm trying to find a VB function that would translate special characters to
their equivalent code in HTML, like "é" becomes "é". But I can't find such a
fonction.. so I still need help!

Thks & Rgds

 

[Steve Rindsberg]

Not it's not FTP - sorry I should have been more accurate. I directly send
XML streams using POST method to a http server.
After investigation, it appears that my problem isn't related to linux, but
it's all on the client side: the data is corrupted when it's added to the DOM
object within VB code.
Does someone know how to prevent it?
I'm trying to find a VB function that would translate special characters to
their equivalent code in HTML, like "é" becomes "é". But I can't find such a
fonction.. so I still need help!

Unless you're using Office 97, it should be simple enough to write a function using
Replace (repeatedly) to do the job.

Function FixMe(sInput as String) as String
Dim sTemp as String
sTemp = sInput
sTemp = Replace(sTemp, "&", "&")
sTemp = Replace(sTemp, " ", "%20")
' and so on
FixMe = sTemp
End Function