Translate Superscript and Subscript texts from Excel to Ucreateprint

82 views
Skip to first unread message

Tim Hoste

unread,
Apr 12, 2021, 10:35:15 AM4/12/21
to XMPie Interest Group
Hello,

I see that all the text symbols that are Superscript in mij Excel file translate to normal text when i generate them in Ucreateprint. Any idea on how this can be resolved?

Thanks

Stik Fortier

unread,
Apr 12, 2021, 1:19:28 PM4/12/21
to XMPie Interest Group
I've used InDesign regex for this in the past.

In my case, there was a business name data field in excel that had superscripted exponents (ex. My Company2 - as in 'My Company squared'). Since it was a predictable pattern I could use regex to superscript the '2'.

This procedure uses InDesign functions only. In other words, XMPie didn't create the superscript.
  1. Create an InDesign Character Style for the superscript
  2. Create an InDesign Paragraph Style
  3. Within this Paragraph Style, create a GREP Style
  4. Set Apply Style to your superscript Character Style created in step 1
  5. Set To Text to the regex pattern (This is tricky if you aren't familiar with regular expressions)
  6. Apply the Paragraph Style to the body of text
It's been awhile so this might be slightly off but should get you in the right direction. There are other ways depending on what's contained in your data.

Michael Sierra

unread,
Apr 12, 2021, 1:49:16 PM4/12/21
to xmpie...@googlegroups.com
Not sure how it’s done elsewhere but we apply a character style using grep to change to superscript.

Mike Sierra
--
You received this message because you are subscribed to the Google Groups "XMPie Interest Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xmpie-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/xmpie-users/9a8d3b21-819c-4920-8dde-88da9721d32an%40googlegroups.com.

Tim Hoste

unread,
Apr 13, 2021, 4:18:33 AM4/13/21
to XMPie Interest Group

Thank you. It worked using GREP styles in indesign
Reply all
Reply to author
Forward
0 new messages