Re: importing a messy text file - Mailing list pgsql-general

From Alberto Cabello Sánchez
Subject Re: importing a messy text file
Date
Msg-id 20140430110341.04d9fcd0ff1b25db5742e87c@unex.es
Whole thread Raw
In response to Re: importing a messy text file  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: importing a messy text file
List pgsql-general
On Wed, 30 Apr 2014 10:47:12 +0200
Willy-Bas Loos <willybas@gmail.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@unex.es>


pgsql-general by date:

Previous
From: David Noel
Date:
Subject: Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)
Next
From: Rémi Cura
Date:
Subject: Re: importing a messy text file