I was not able to find any details about "\S+\s+ ", can u explain them? Also thanks a lot, this worked perfectly!
On Wed, Nov 18, 2015 at 4:36 PM, Hans Ginzel <hans@matfyz.cz> wrote:
On Wed, Nov 18, 2015 at 01:49:35PM +0100, Shmagi Kavtaradze wrote:
I am importing sentences from txt file. They look like: "0,170 A recent statistical analysis by David Barton graphically illustrates how America has plummeted from righteous living , prosperity and success in the last quarter century . Each Sentence starts with coordinates and each word is delimited with tab. I want to import data to tables without coordinates, just text and if possible to convert tab delimited space with just 'space', not to have such a gap between words. Any solutions how to do it? maybe with shell script?
-- DROP TABLE IF EXISTS Sentence; CREATE TABLE IF NOT EXISTS Sentence (s text); COPY Sentence FROM PROGRAM 'sed -re ''s/\t/ /g; s/^\S+\s+//'' file.txt' WITH (FORMAT text, NULL '');
Take care of escape sequences – backslashes in the file.