Paradox Community

Items in pnews.paradox-development

Subject:Re: Import .CSV
Date:13 Feb 2022 12:05:58 -0400
From:"Kevin Zawicki" <numberjack@wi.rr.com>
Newsgroups:pnews.paradox-development

"Fabio Spaggiari" <fabiospagg@gmail.com> wrote:
>
>Hi all .
>I need to import a .CSV file from a web application that export data in
this
>format.
>When I try to read it , in several way ,both objectpal or interactive paradox
>fail when encounter the first record separator
>This is an unprintable caracter made by pressing Shift + Enter
>I can see it opening the file by word or officewriter 
>and the symbol showed is like a downleftarrow , but 
>I can't end import ..
>Any tips ?
>Regards , Fabio
>

using the file import and not textstream?


it might be a UTF-8 file.
open file in notepad, choose save as, look at the encoding at bottom... 
is it UTF-8?

if so, change to ANSI and save (to different file name)

try to import new file name

if you need to automate this I have some code


Copyright © 2004 thedbcommunity.com