tu 18
_
Greetings, Pascal CROZET
DBA - Qualis Consulting
_
ot;Adrian Klaver"
wrote:
On 10/10/19 8:30 AM, PASCAL CROZET wrote:
> Thanks,
>
>
> As it's write in the page,
> the file format is
> more a convention than a standard.
>
>
> With collegues, we've find the solution with a regex in sed
>
#x27;';';
EXECUTE request;
The function call :
select insert_into_db_sources_csv('/DATA/input/files/Extract_software.csv',
't_m03_software', ',', 'HEADER');
If the import fails, TRUNCATE isn
inside","last field"
When I import this line in a table, with the exact column number, with the «
copy » command in plpgslq, the import fails.
Saying that too many fields are present.
I tried to catch the double quotes and delete then, but that’s hard under AWK
or sed
_
