$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
0

​How to include quotations in a string calculation?

Nov 14, 2016 at 04:02 PM

45

avatar image
Former Member

SAP Lumira Desktop

Version: 1.31.1

Build: 122

I am trying to write a calculation that will return an html string that looks like this:

<a href="https://community.landesk.com/docs/DOC-42244" target="_blank">Author - Title</a>

You'll notice that there are quotation marks in the string, and those need to be there for my purpose. (Single quotes will not be honored by the html application I'm using the string within) I have a calculation that should give me the above output and it looks like this:

if {Division} = "LANDESK" 
then ("<a href=\"https://community.landesk.com/docs/DOC-" + {Documentnumber} + " target=\"_blank\"> " + {Name} + " - " + {Title} + "</a>") 
else ("No result") 

I can save this formula without an error.

However when I try to export the data to a csv, I get an error:

Internal error: Error: [RCI_CE_00035] - [Cannot execute the query.Velocity Engine
does not support this workflow: HL(12): A std::exception did happen during call.
{0} (An error occured during code compilation
SELECT DISTINCT
if(T1."id_58" = V'LANDESK') is null then null else if (T1."id_58" = V'LANDESK') then
((((((V'<a href="https://community.landesk.com/docs/DOC-' + to_varchar(T1."id_1")) +.... 

(I can't copy paste the error message which is super annoying, so that's as much as I was willing to write up manually.)

I have included a screenshot of the error it throws.

If I remove the \" the export is successful.

So it seems related to me trying to escape the quotation mark.

So my question is:

How can I include quotations in a string calculation?

If I am supposed to escape the quotation character, what is the escape character? If backslash is the escape character, then there may be a bug with how it behaves?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers