loadcsv and accent

C

claveriel

Member

• Jun 21, 2007

• #1

hello,
i use the function : Tableinterv.LoadCSV("interv.csv", ";", 0,true)
to load a csv file in a table, it works but in french we have caracter with accent for exemple : é
all caracters with accent are ingnored

example: the word été become t.

can you help me ?

 

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 21, 2007

• #2

LoadCSV does support accent characters (it uses UTF-8 encoding).
How did you create the CSV file?
Microsoft Excel doesn't support accent characters when you save CSV files.

 

C

claveriel

Member

• Jun 21, 2007

• #3

i create myself the csv file, i don't use excel.

i 'll work without accent.

thank you for the answer
claveriel

 

RandomCoder

Well-Known Member

Licensed User

Longtime User

• Jun 21, 2007

• #4

I think that you could use XML format instead and retain the accent.

Regards,
RandomCoder

 

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 21, 2007

• #5

Again, there is no problem to work with accent characters.
How did you create the CSV file?
Did you save it encoded with UTF-8?

 

C

claveriel

Member

• Jun 21, 2007

• #6

To create my csv, i export my data from an other sotfware.
i want to modify and create datas in the pocket pc. I save the data to a csv file in the pocket.

After the csv files go to the pc with activesync.
and i import my data into my other software.

this en exemple of a c sv file :

barthe;2004;N;Maïs consommation;10.88
cousin;2004;N;Maïs consommation;0
pignada;2004;N;Graines fourragères;60.46

 

Last edited: Jun 21, 2007

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jun 21, 2007

• #7

Try to load this file (it is the data you've posted).
It was created with Notepad and it was saved encoded with UTF-8.

 

Attachments

• 1.txt

  120 bytes · Views: 263

C

claveriel

Member

• Jun 21, 2007

• #8

Ok it's good ,

thank you Erel

 

Y

yildi

Member

Licensed User

• Nov 15, 2007

• #9

I have the symmetrical problem: In the small soft I have developed, I save some data using Table.SaveCSV but if I open it in ThinkingRock (which is a Java program), I get garbage (the unicode indicator at the beginning and garbaged accented characters). Is there a way to convert to high ASCII the text saved in the CSV file, instead of UTF8? Or, how can I export data containing accented characters with SaveCSV to a software that does not seem to understand the Unicode?

Thank you very much in advance.

Murat

 

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Nov 15, 2007

• #10

What encoding does your other application use?
If you know the code page you can convert the entire text using two Bitwise objects.
This is the list of code pages: http://msdn2.microsoft.com/en-us/library/ms776446.aspx

 

Y

yildi

Member

Licensed User

• Nov 15, 2007

• #11

Thanks Erel,

But I think we are higher than my computing competency here (I am a random coder much more random than RandomCoder ;-) ). I do not know the code page. I am surprised that this program does not understand Unicode, at least for this function... You are of course write (my question is stupid); there is nothing like high ASCII without a corresponding code page...

I have asked the question at ThinkingRock user forums. We will see if someone has an answer...

Regards,

Murat