Newbie question _ Strange simbol instead accented letters

[coslad]

Hi

my problem is that if a load a csv file into a listview with LoadCSV function , all accented letters appears like this symbol :

How does it mean ?

 

[mc73]

Did you save your csv in utf-8 encoding?

 

[coslad]

I don't know, I saved from excel.


Inviato dal mio H9500 con Tapatalk 2

 

[mc73]

You can try saving your csv from excel, by first choosing tools->web options->encoding->Unicode(UTF-8) at the left bottom of the 'save as...' window. I think this can help.

 

[Erel]

Excel (at least older versions of Excel) do not support CSV files with encoding other than ASCII.

 

[agraham]

Forgive my being pedantic - yet again! I still use Office XP Professional (Office 2002) and I think early versions actually save csv files coded in the code page of the current system locale as set in the Administrative tab of Region and Language in Control Panel for Windows 7, or Region in Control Panel for Windows 8. It's on the Advanced tab in Regional and Language Options for Windows XP.

As I understand it a strict ASCII code page only contains characters for the values from 0 to 127.

 

[mc73]

I think you are correct. However, in later versions, under options->popular, there is a combo for selecting editing languages, bypassing (probably) the regional settings of windows.

Anyway, about the conversion, I've just tried my advice in office 2007, it didn't work as expected. My bad, after all, I am always using openOffice for csv handling

 

[coslad]

I have used office 2007,but doesn't matter.
I tried open notepad and write:

Prova;l'altro

And saved as a txt and renamed csv.

In the list view the string "l'altro" appear "l?altro"

I become crazy

Inviato dal mio GT-P7510 con Tapatalk 2

 

[Erel]

I recommend you to use Notepad++. Notepad++ is an excellent text editor and will allow you to save your file with UTF8 encoding.

 

[coslad]

Hi,
I solved in this way:

After saved csv from excel2007, i open the text file with notepad (win7) and save the file selecting utc encoding and not ascii.
Thanks

Inviato dal mio GT-P7510 con Tapatalk 2

 

[mc73]

Haven't tried with win7 notepad, but with Vista notepad, there is a problem with the very first character of the file (BOM). Guess it didn't matter in your case, but caused me problems in the past. If you open your edited file with jEdit for example, you may easily see what I'm referring too. Anyway, glad you fixed your problem, and Erel's suggestion (notepad++) is really good, even if I'm still using jEdit for some reasons.