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.palayret@meteo.fr
> Fixe : +33 561078319


-- 
Adrian Klaver
adrian.klaver@aklaver.com