Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Select an option

  • Save antoniolocandro/fad49a816b7708f36c7bfb89638e7031 to your computer and use it in GitHub Desktop.

Select an option

Save antoniolocandro/fad49a816b7708f36c7bfb89638e7031 to your computer and use it in GitHub Desktop.
'<b>' || "NAME" || '</b>' ||
'<p style="margin:0; text-align:center;">' ||
coalesce("UPPERLIMIT",'') ||
'</p>' ||
'<p style="margin:0; text-align:center;">' ||
'<span style="text-decoration: overline;">' ||
CASE
WHEN length("LOWERLIMIT") < length("UPPERLIMIT") THEN
repeat('&nbsp;', (length("UPPERLIMIT")- Length("LOWERLIMIT"))-1) ||
coalesce("LOWERLIMIT",'') ||
repeat('&nbsp;', (length("UPPERLIMIT") / 2))
WHEN length("LOWERLIMIT") > length("UPPERLIMIT") THEN
coalesce("LOWERLIMIT",'')
ELSE
coalesce("LOWERLIMIT",'')
END ||
'</span></p>' ||
'<p style="margin:0; text-align:center;">' ||
coalesce("FREQUENCY",'') ||
'</p>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment