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.
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
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.
