Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #8053
| From | "Fred Killet" <info@killetsoft.de> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) |
| Date | 2015-05-06 12:13 +0200 |
| Organization | albasani.net |
| Message-ID | <micph4$fia$1@news.albasani.net> (permalink) |
| References | <23619998-fe76-40de-9402-0b873aa6b4be@googlegroups.com> |
Hi Frans,
use the program CONVERT. It handles input file, output file and a parameter
file from the command line.
"CONVERT data converter freeware converts databases and files between the
file formats dBase, CSV and SDF and the character sets ANSI, ASCII, UTF8 and
Unicode and allows in the same time to sort the data and to do selections."
It is written completely in VO and it is fast.
Download from http://www.killetsoft.de/p_cona_e.htm. If you use it not
commercialy it is free.
Fred Killet
killet-nospam@killetsoft.de
"Frans Wauters" <info@wautersit.com> schrieb im Newsbeitrag
news:23619998-fe76-40de-9402-0b873aa6b4be@googlegroups.com...
Greetings all,
Lately I receive (from third parties) very big CSV text files in several
formats and I look for a way to detect in which format I can read the
content correctly and/or convert them to/from ANSI or UNICODE etc...
When I use notepad, I can read and see all data correctly. Notepad and
Notepad++ is capable to read all these different text file formats. However
when I perform a type in and CMD box, I can't read some files correctly. In
notepad, and when I using "save as", I can see that some files are in ANSI
where other are in UNICODE and even UTF-8.
Example: Use notepad and copy/past the following 20 chars:
àäâãéèëêïîöôõùüû EURO$£¥
In notepad, use the "save as" option and save it 3 times, as an ANSI, as
UNICODE and as UTP-8 file.
Quick test code ( console application ) or use TYPE <filename> in a DOS box
or even an hexeditor to see the difference in txt format.
FUNCTION Start()
LOCAL cTxt AS STRING
LOCAL i AS DWORD
? cTxt := MemoRead( "test-ansi.csv" )
?
?
FOR i := 1 TO Len( cTxt )
?? StrZero( Asc( SubStr( cTxt, i , 1 ) ), 3 ) + " " + SubStr( cTxt, i
, 1 ) + " "
NEXT
?
WAIT
RETURN NIL
Kind regards,
Frans
---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
http://www.avast.com
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) Frans Wauters <info@wautersit.com> - 2015-05-06 02:02 -0700
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) Frans Wauters <info@wautersit.com> - 2015-05-06 02:04 -0700
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) Frans Wauters <info@wautersit.com> - 2015-05-06 07:17 -0700
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2015-05-06 11:16 +0200
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) Frans Wauters <info@wautersit.com> - 2015-05-06 02:47 -0700
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) "Fred Killet" <info@killetsoft.de> - 2015-05-06 12:13 +0200
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) Frans Wauters <info@wautersit.com> - 2015-05-06 04:26 -0700
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2015-05-06 15:43 +0200
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) "Fred Killet" <info@killetsoft.de> - 2015-05-08 17:28 +0200
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2015-05-10 21:04 +0200
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) "Philippe Bayard (Belgium)" <philbayard@gmail.com> - 2015-05-06 03:58 -0700
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) Frans Wauters <info@wautersit.com> - 2015-05-06 04:19 -0700
Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... ) "Arne Ortlinghaus" <Arne.Ortlinghaus@acs.it> - 2015-05-09 09:06 +0200
csiph-web