Re: Removing Last field from CSV string

On 5/16/20 9:31 AM, PALAYRET Jacques wrote:
> 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.

That's cool. I did a little fiddling with above:

SELECT
substring(
left('Class V,Class VI,Class VII,Competitive Exam,Class VIII,Class
X,Class XI,Class IX,Class XII', 60), 1, length(
left('Class V,Class VI,Class VII,Competitive Exam,Class VIII,Class
X,Class XI,Class IX,Class XII', 60)) - position(',' IN reverse(
left('Class V,Class VI,Class VII,Competitive Exam,Class VIII,Class
X,Class XI,Class IX,Class XII', 60))))

substring
--------------------------------------------------------
Class V,Class VI,Class VII,Competitive Exam,Class VIII

> Regards
> ----- Météo-France -----
> PALAYRET JACQUES
> DCSC/MBD
> jacques(dot)palayret(at)meteo(dot)fr
> Fixe : +33 561078319

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com