Re: importing data from Filemaker: weird newline characters

From: Frank Joerdens <frank(at)joerdens(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Cc: hank(at)fas-art(dot)com
Subject: Re: importing data from Filemaker: weird newline characters
Date: 2002-01-23 14:58:18
Message-ID: 20020123155818.A17904@superfly.archi-me-des.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Jan 23, 2002 at 02:14:06AM +0100, Frank Joerdens wrote:
> On Mon, Jan 21, 2002 at 05:21:17PM -0600, Ross J. Reedstrom wrote:
[ . . . ]
> > Where the ^K and ^M are actual control codes (generated in bash with
> > ^I^K and ^I^M) should do it.

On my terminal it's Control-V, which is bound to Readline's quoted-insert
function (found that eventually).

sed 's/^K/^M/g' old.csv > new.csv

does the trick now.

Thanks!
Frank

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-01-23 16:00:28 Re: ERROR (Bug?) in RULE processing ?
Previous Message Tom Lane 2002-01-23 14:56:45 Re: pltcl build problem on FreeBSD (was: Re: pltlc and pltlcu problems)