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	May 16, 2020 19:31:30
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
List	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.palayret@meteo.fr
Fixe : +33 561078319

From: Rob Sargent
Date: 16 May 2020, 19:03:21
Subject: Re: schema agnostic functions in language sql

From: Adrian Klaver
Date: 16 May 2020, 19:53:17
Subject: Re: Removing Last field from CSV string