Re: importing a messy text file

From: Alberto Cabello Sánchez <alberto(at)unex(dot)es>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: importing a messy text file
Date: 2014-04-30 09:03:41
Message-ID: 20140430110341.04d9fcd0ff1b25db5742e87c@unex.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 30 Apr 2014 10:47:12 +0200
Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:

> Alberto, it would be hard to use sed( s/^I$// ), because there is no
> explicit NULL value and there are many NULLs in the last column.
> So i can't be sure how many tabs should be in the end of each line.

Ok, I understand (I think).

What about using "cut" to strip the extra fields?

--
Alberto Cabello Sánchez
<alberto(at)unex(dot)es>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rémi Cura 2014-04-30 09:06:19 Re: importing a messy text file
Previous Message David Noel 2014-04-30 08:50:27 Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)