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
|