antp.be forum

I'm trying to import ed2k information from an excel and when I export the excel information to a csv file the special characters change or disappear.
Can I import from excel in a different way not using the csv conversion step? Or is it a way to export from excel to csv without losing the special characters?
If I change a ed2k link it will not work.

What kind of special characters are these?
If they are unicode characters, AMC won't support them anyway. They could be encoded, but I am not sure it is easy to do it Excel.

antp wrote:What kind of special characters are these?
If they are unicode characters, AMC won't support them anyway. They could be encoded, but I am not sure it is easy to do it Excel.

ñ á é í ó ú , in spanish are very usuall

These should not cause problem... what do they change to?
What do you select in Excel as format when exporting to CSV?

antp wrote:These should not cause problem... what do they change to?
What do you select in Excel as format when exporting to CSV?

It changes to estrange symbols, maybe I can see to witch symbol it changes every one and make a search with it, but will take long time.
I export to MsDos Csv

Well there's the problem. AMC is not a DOS program, it is a Windows program
Take the other CSV of the list, the non-DOS one

antp wrote:Well there's the problem. AMC is not a DOS program, it is a Windows program
Take the other CSV of the list, the non-DOS one

The other version is the Macintosh version. The other versions that I give you is XML data, web, text, XML 2003, Excel 5.0/95, CSV separated with comas, text with format separated with spaces, Dif, SYLK, Worksheet OpenDocument, XPS document and PDF.

"CSV separated with comas", that's the one.
"CSV" means "comma-separated values", I do not know why they used such redundant name.
From what I recall, "Text" used tab-delimited fields, which can also be used by AMC.