Adobe DC - custom format 12 numbers to include dashes

Forum|Forum|8 years ago
July 2, 2017
2 replies
3027 views

Adobe DC - I am trying to import a number from Excel that has no dashes into a pdf file that will insert the dashes. Is this possible ? ie 123456789012 in excel and I want it to look like 123-456-7890-12 when in the pdf. Do I need to do a Java script? If yes could you tell me how to write it?

This topic has been closed for replies.

colettel75944671Author

Participant

Thank you, would you please give me the script for the 12 digit format? 111-222-3333-44?

JR Boulay

Community Expert

123456789012 in excel and I want it to look like 123-456-7890-12 when in the pdf

Properties : Format : Special : Arbitrary Mask

Acrobate du PDF, InDesigner et Photoshopographe

try67

Community Expert

I thought so also, but that doesn't work when you import the data from an external source...

try67

Community Expert

No, that won't work. You need to give the values the correct format before

importing them to the PDF.

On Mon, Jul 3, 2017 at 12:33 AM, colettel75944671 <forums_noreply@adobe.com>

try67

Community Expert

Sorry, my reply above is not entirely correct. You can do is using a script... For example, to format a 6-digit number as "123-456" you can use this code as the custom Format script:

if (/^\d{6}$/.test(event.value)) event.value = event.value.substring(0,3)+"-"+event.value.substring(3);

colettel75944671Author

Participant

Thank you, would you please give me the script for the 12 digit format? 111-222-3333-44?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded