Adobe DC - custom format 12 numbers to include dashes

10 replies
3062 views
Translate

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 is closed to new replies. Start a new post to keep the conversation going.

colettel75944671Author

Participant

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

Translate

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

Translate

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...

Translate

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>

Translate

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);

Translate

colettel75944671Author

Participant

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

Translate

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.