How to format price ? whitout Grep in Publisher

[Curb72]

Hi.

Im using data merge to create an cataloge. but....

Q: How can i format price? (on the products) 

I dont want just 3.99 but want the 99 to be superscript to aviod using " . ".

I understand that its no GREP in publisher, but are there other ways ??

Thanks for your reply.

 

[garrettm30]

On 1/17/2022 at 12:57 PM, Curb72 said:

I understand that its no GREP in publisher, but are there other ways ??

Yes and no on that GREP thing. For one thing, Publisher calls it by the more standard name "regular expression." But that's just academic. Just so you know that what you are looking for in the Affinity UI is called "regular expressions."

Now for the yes and no - Publisher can find and replace by regular expressions, which is what I would suggest you do to format the price. What it cannot do is have regular expressions as part of style definitions.

Here is a quick try at formatting the decimals to be superscript:

Note that you need to click the cog above the Find field to activate regular expression mode. And you click the cog above the Replace with field to set the format as desired, such as applying Superscript literally as I have done here, or better yet, a character style that you have set up for superscripts.