Topic Options
#57119 - 06/14/19 02:35 PM Remove a coma in a number on a PDF (workflow)
Luc Offline
OL Toddler

Registered: 02/26/15
Posts: 31
Loc: Montreal
Hi, I'm trying to sort on metadata a pdf on a number, but sometimes the numbers have a coma in it ex. (3,550) and it gives me an error(not numeric) how can I remove that coma from that number before I do the sort?

#57120 - 06/17/19 10:40 AM Re: Remove a coma in a number on a PDF (workflow) [Re: Luc]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 459
Loc: Québec, Canada
You would have to extract the metadata value into a variable/jobInfo.

Then, in a script, remove the comma from that variable.

After that, put back the new value into the metadata using the Metadata Fields Management plugin.