topic Re: How do I get commas between my keywords in ODS PDF metadata without triggering quotation marks? in New SAS User

How do I get commas between my keywords in ODS PDF metadata without triggering quotation marks?

formerRuser — Wed, 01 May 2019 20:04:12 GMT

Hello community,

I am using ODS PDF to create PDFs in SAS 9.4, and I'm encountering a problem when adding keywords to the properties/metadata for my PDFs (using this: http://support.sas.com/documentation/cdl/en/graphref/65389/HTML/default/viewer.htm#p01sq0s49g1pxon1pc5ktjcjxfvx.htm)

In the properties of the PDFs for Keywords I want to see this:

key word1, key word2, key word3

My keywords have spaces in them, so I need to separate them with commas to meet company guidelines. However, if I write keywords="key word1, key word2, key word3" then double quotation marks show up around the entire list in the properties. If I write keywords="key word1 key word2 key word3" then I don't get double quotation marks in the properties, but I don't get my commas either. Semi-colons do not work either.

Is there any way that I can get commas between my keywords but not have quotation marks around the entire list? I need two word keywords to be recognized as one unit and not two separate keywords. Manually deleting the quotation marks after production is not feasible because I am generating thousands of PDFs.

Thank you in advance. I searched but could not find an answer to this elsewhere.

Re: How do I get commas between my keywords in ODS PDF metadata without triggering quotation marks?

ballardw — Wed, 01 May 2019 20:11:47 GMT

Can you show the code you are currently using?

Re: How do I get commas between my keywords in ODS PDF metadata without triggering quotation marks?

Reeza — Wed, 01 May 2019 20:33:13 GMT

I ran into this problem in 2013 and we had to use a small Adobe JS script to fix it in the end. It was a pain. I hope there's a better solution today! Otherwise, if you have access to Adobe Pro, the scripting tools are quite handy.

Re: How do I get commas between my keywords in ODS PDF metadata without triggering quotation marks?

formerRuser — Wed, 01 May 2019 20:45:50 GMT

Hello,

Here's the code which produces commas but also produces quotation marks:

ods pdf file="filepath\filename.pdf"
title = "title of PDF"
author = "author here"
subject = "subject here"
keywords = "keyword, keyword, key word, key word, key word"
style = manual_style
dpi=500
accessible
notoc;

I've also tried single quotation marks, but it still produces double quotation marks.

Re: How do I get commas between my keywords in ODS PDF metadata without triggering quotation marks?

formerRuser — Wed, 01 May 2019 21:01:46 GMT

Well it's good to know I'm not alone. I hope so, too. I do not currently have access to Adobe Pro unfortunately, but thank you for the suggestion.

Re: How do I get commas between my keywords in ODS PDF metadata without triggering quotation marks?

Cynthia_sas — Thu, 02 May 2019 15:43:02 GMT

Hi, Taking SAS out of the picture, I made a test document with Word and put keyword tags into Word without any quotes and with a comma separating the 2 keywords, as shown below:

Apparently, something in the creation of the PDF file causes the quotes to be added and it is not something unique to SAS, since it happens when SAS is not involved in making the PDF file.

So I think you are dealing with Adobe behavior the requires quotes because as long as there is no punctuation like commas or colons, etc, I get this in the PDF file:

Hope this helps,

Cynthia

Re: How do I get commas between my keywords in ODS PDF metadata without triggering quotation marks?

Tom — Thu, 02 May 2019 16:42:38 GMT

Why do your keywords include spaces?

If you must use spaces in your keywords then perhaps you can use some other character like | ^ ! ~ + to separate the multiple "words".

Re: How do I get commas between my keywords in ODS PDF metadata without triggering quotation marks?

formerRuser — Fri, 03 May 2019 16:38:38 GMT

Okay that's interesting. Thank you for investigating!