topic Passing a quotation mark to a select string from macro in QlikView

Passing a quotation mark to a select string from macro

Tue, 30 Aug 2011 16:27:01 GMT

I am trying to create a button to automatically select a couple items from a field. If I were to just type in the select string it would be :"AF "|"N "|"MC "|"A ". However I can't pass the quotes in the macro. I have tried multiple things, such as """ to get around it, but nothing is working. Any suggestions?

Thanks in advance,

Therese

Re: Passing a quotation mark to a select string from macro

tanelry — Wed, 31 Aug 2011 09:33:23 GMT

Use chr(34) in macro

v = "(" & chr(34) & "AF " & chr(34) & "|" & chr(34) & "N " & chr(34) & ")"
ActiveDocument.Fields("FieldName").Select v

If you use QV10 then better assign "select in field" action for button instead of macro,

with static select string as ("AF "|"N ")

or calculated as ='(' & '"AF "' & '|' & '"N "' & ')'

Passing a quotation mark to a select string from macro

Wed, 31 Aug 2011 16:46:01 GMT

Thanks... I had actually gotten to there a couple days ago, but had my quotes in there wrong. I didn't realize until I had it set a variable as the string I created.

Thanks!