Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #8053

Re: CSV text files in several formats ( ANSI, Unicode, UTF-8, ... )

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>

Show all headers | View raw


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


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