Technische forums » Office applications »
Correcting "junk" characters in .csv file
De persoon die dit onderwerp heeft geplaatst: Reed James
Reed James
Reed James
Chili
Local time: 06:47
Lid 2005
Spaans naar Engels
May 20, 2009

Hello.

I have been using Systran Premium 6 to extract terminology from source files and export the results to a .csv file. When I open the .csv file in Excel, Spanish accented characters are represented by funny characters that bear no resemblance to what they should be. Instead of deleting these characters and replacing them with the proper ones, is there anything I can do to get the .csv file to read properly? TIA
 
Adam Łobatiuk
Adam Łobatiuk  Identity Verified
Polen
Local time: 12:47
Lid 2009
Engels naar Pools
+ ...
Use anything that opens text files and lets you choose the encoding May 20, 2009

CSV files are just text files, and you can open them e.g. in Word. It will display a "Text Import Wizard" where you can select and preview various encodings. Once you find the right one, choose it and open the file. Save it as another text file, close and change the extension from .txt to .csv.

HTH
 
Antoní­n Otáhal
Antoní­n Otáhal
Local time: 12:47
Lid 2005
Engels naar Tsjechisch
+ ...
Freeware CSVed, uniCSVed May 21, 2009

http://home.hccnet.nl/s.j.francke/software/software.htm

Antonin
 
Fazil Aktekin
Fazil Aktekin
Turkije
Local time: 13:47
Engels naar Turks
+ ...
It's unicode problem May 21, 2009

There is a simple way to correct it; loading the appropiate language into Windows by visiting Control Panel-> Regional and Language Settings and adding appropiate language and then in the Regional and Language Settings, at the "language" tab, under "Text Services and Input Languages", click on "Details". On the popped up window, choose "advance" tab and confirm the "Extend support of advanced text services to all programs" check box. Thus you can see any unicode character even in Notepad.
... See more
There is a simple way to correct it; loading the appropiate language into Windows by visiting Control Panel-> Regional and Language Settings and adding appropiate language and then in the Regional and Language Settings, at the "language" tab, under "Text Services and Input Languages", click on "Details". On the popped up window, choose "advance" tab and confirm the "Extend support of advanced text services to all programs" check box. Thus you can see any unicode character even in Notepad.
PS: My OS is Windows XP Professional. ▲ Collapse
 
Jeff Allen
Jeff Allen  Identity Verified
Frankrijk
Local time: 12:47
Meerdere talen
+ ...
other post about systran dictionary exports causing issues Aug 29, 2009

I just posted something about Systran importing and exporting to another forum here:

http://www.proz.com/forum/sdl_trados_support/135962-systran6pro_to_trados2007.html#1205638

See if that info might be of help.

Jeff
 


To report site rules violations or get help, contact a site moderator:

Moderator(en) van dit forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

Correcting "junk" characters in .csv file






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »