Skip to main content
DBC-CUBIC
Participant
February 21, 2019
Answered

%0D being added to all URL's

  • February 21, 2019
  • 13 replies
  • 18744 views

Hi, I have a problem that I can't find the anwser to, so I'm hoping that you can help.

I'm making a new manual at work, and I have about 600 URL's that I've transfered over from excel.

When I export the file to PDF (Interactive) it auto adds %0d to my URL's so insted of sending the user to: https://www.mysite.eu/the_file.pdf the URL will say http://www.mysite.eu/the_file.pdf%0D

If I then go and delete the %0D from the browser line, the URL workes just fine.

So my question is, how do I get rid of the %0D when exporting to pdf ??

Here is a list of things that I've tried already:

- Export with "Shared destination" checked

- Export with "Shared destination" un-checked

- Checking in excel that the URL don't have any line breaks

- Checking in excel that the URL don't have "carriage return"

- Copying the URL to notepad, and from there to InDesign

- Typing the URL in InDesign manual

Nothing of this has worked for my.. Please help if you can.. The manual will be send out to our customers world wide, so it needs to work..

Correct answer BobLevine

Oh sorry..

I'm just using simple copy paste.

Marking the text in excel and then using "Ctrl+C" to copy, and then inserting it in InDesign using the "Insert new hyperlink" function.

I don't know if it makes a diffrence, but I'm inserting my hyperlink on an image insted of a text.


Try to place the Excel file into InDesign instead of pasting it.

13 replies

Community Expert
November 5, 2019

Hi InbalZissu,

well, you are right. The issue discussed in this thread is: Something, %0D is added to a URL hyperlink destination.

We could try a scripting solution similar to the one in the other thread I linked to.

 

I'd like to write a script that is doing this: Remove the extra %0D off the end of the URL if this %0D is already visible in the URL of the hyperlink in InDesign. At least I can test if something, a special character perhaps, is added at the end and when exported to PDF transfers to %0D in the link. Can you provide a sample InDesign document for testing some script code? Together with the exported PDF?

 

Upload the documents zipped to Dropbox or a similar service and provide the download link.

 

Thanks,
Uwe Laubender

( ACP )

 

Participating Frequently
November 11, 2019

Hi

When I look at the links in the indesign file I don't see that addition, but here are the files:

INDD: https://drive.google.com/file/d/1J9sucLAinWpq3k1KTtvNXnnSTJUVF040/view?usp=sharing

PDF: https://drive.google.com/file/d/1JMLNKQJc8-8HaASAVomFsSx9BzyWGDvP/view?usp=sharing

 

Thank you

Community Expert
November 11, 2019

Sorry. I have no Google Account and I'm not willing to add one.

So I cannot download your files.

 

Regards,
Uwe Laubender

( ACP )

Community Expert
November 5, 2019

Hi InbalZissu,

I think this is a very old issue.

 

See into this thread from 2012 to test the scripting solution ( ExtendScript/JavaScript )

https://community.adobe.com/t5/InDesign/CS6-hyperlink-problem/m-p/4218626#M14486

 

Regards,
Uwe Laubender

( ACP )

Participating Frequently
November 5, 2019

Thank you for your reply, but it's not old at all.

This discussion is from Feb this year.

I didn't find an answer in the link you've sent me.

BobLevine
Community Expert
Community Expert
February 21, 2019

How are moving this info from Excel to ID? What version of ID? What version of Excel? What operating system?

DBC-CUBIC
DBC-CUBICAuthor
Participant
February 21, 2019

I'm using:

Windows 10 (64 bit)

InDesign CC version 14.0.1 x64

Excel 2013

BobLevine
Community Expert
Community Expert
February 21, 2019

You still didn’t tell us how you’re moving from Excel to InDesign.