Re: Removing Last field from CSV string

From: PALAYRET Jacques <jacques(dot)palayret(at)meteo(dot)fr>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Removing Last field from CSV string
Date: 2020-05-16 16:31:30
Message-ID: 786586020.3966730.1589646690749.JavaMail.zimbra@meteo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)palayret(at)meteo(dot)fr
Fixe : +33 561078319

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-05-16 16:53:17 Re: Removing Last field from CSV string
Previous Message Rob Sargent 2020-05-16 16:03:21 Re: schema agnostic functions in language sql