Auf Thema antworten

Beitrag

Kann das so funktionieren?
[CODE=sql] -- Staffel und Episode aus Kurztext, falls vorhanden
-- Beispiel: KKP S02 E04. Als der Start von Keefs neuer Initia…
case when epi_season is Null then
case when sub_shorttext is Null then '' else
case when REGEXP_INSTR(sub_shorttext, 'S[0-9]+ ') != 0 then
concat('||Staffel: ', TRIM(LEADING '0' FROM TRIM(LEADING 'S' FROM REGEXP_SUBSTR(sub_shorttext, 'S[0-9]+')))) else
case when REGEXP_INSTR(sub_shorttext, 'Staffel [0-9]+') != 0 then
concat('||Staffel: ', TRIM(LEADING '0' FROM TRIM(LEADING 'Staffel ' FROM REGEXP_SUBSTR(sub_shorttext, 'Staffel [0-9]+')))) else
''
end end end
else
concat('||Staffel: ', cast(epi_season as char)) end,
[/CODE]

<blockquote data-quote="MegaV0lt" data-source="post: 44041" data-attributes="member: 5795">Kann das so funktionieren?[CODE=sql]&nbsp; &nbsp; -- Staffel und Episode aus Kurztext, falls vorhanden&nbsp; &nbsp; -- Beispiel: KKP S02 E04. Als der Start von Keefs neuer Initia…&nbsp; &nbsp; case when epi_season is Null then&nbsp; &nbsp; &nbsp; case when sub_shorttext is Null then &#039;&#039; else&nbsp; &nbsp; &nbsp; &nbsp; case when REGEXP_INSTR(sub_shorttext, &#039;S[0-9]+ &#039;) != 0 then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; concat(&#039;||Staffel: &#039;, TRIM(LEADING &#039;0&#039; FROM TRIM(LEADING &#039;S&#039; FROM REGEXP_SUBSTR(sub_shorttext, &#039;S[0-9]+&#039;)))) else&nbsp; &nbsp; &nbsp; &nbsp; case when REGEXP_INSTR(sub_shorttext, &#039;Staffel [0-9]+&#039;) != 0 then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; concat(&#039;||Staffel: &#039;, TRIM(LEADING &#039;0&#039; FROM TRIM(LEADING &#039;Staffel &#039; FROM REGEXP_SUBSTR(sub_shorttext, &#039;Staffel [0-9]+&#039;)))) else&nbsp; &nbsp; &nbsp; &nbsp; &#039;&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; end end end&nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; concat(&#039;||Staffel: &#039;, cast(epi_season as char)) end,[/CODE]</blockquote>

[QUOTE="MegaV0lt, post: 44041, member: 5795"] Kann das so funktionieren? [CODE=sql] -- Staffel und Episode aus Kurztext, falls vorhanden -- Beispiel: KKP S02 E04. Als der Start von Keefs neuer Initia… case when epi_season is Null then case when sub_shorttext is Null then '' else case when REGEXP_INSTR(sub_shorttext, 'S[0-9]+ ') != 0 then concat('||Staffel: ', TRIM(LEADING '0' FROM TRIM(LEADING 'S' FROM REGEXP_SUBSTR(sub_shorttext, 'S[0-9]+')))) else case when REGEXP_INSTR(sub_shorttext, 'Staffel [0-9]+') != 0 then concat('||Staffel: ', TRIM(LEADING '0' FROM TRIM(LEADING 'Staffel ' FROM REGEXP_SUBSTR(sub_shorttext, 'Staffel [0-9]+')))) else '' end end end else concat('||Staffel: ', cast(epi_season as char)) end, [/CODE] [/QUOTE]

Authentifizierung