Postgres Pro
Downloads
Home   >   mailing lists

Re: Removing Last field from CSV string - Mailing list pgsql-general

From PALAYRET Jacques
Subject Re: Removing Last field from CSV string
Date
Msg-id 786586020.3966730.1589646690749.JavaMail.zimbra@meteo.fr
Whole thread Raw
In response to Removing Last field from CSV string  (Alex Magnum <magnum11200@gmail.com>)
Responses Re: Removing Last field from CSV string  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Hello,

Perhaps, a statement like :
   substring(theString, 1, length(theString)-position(',' IN reverse(theString)))

with theString   'Class V,Class VI,Class VII,Competitive Exam,Class VIII*,Class'  for example.
Regards
----- Météo-France -----
PALAYRET JACQUES
DCSC/MBD
jacques.palayret@meteo.fr
Fixe : +33 561078319

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: schema agnostic functions in language sql
Next
From: Adrian Klaver
Date:
Subject: Re: Removing Last field from CSV string