Should "document amount" return with or without $ and comma?

DEVONthink Automation
1

I’m trying to use “document amount” to pull the bill amount from email.
set theAmount to document amount of theRecord

Sometimes the string returned has a dollar sign and/or a comma, sometimes it doesn’t. For example, one email returned $1,187.00 (exactly as it was rendered in the email), while another returned 1352.00 although the email text was $1,352.00. These billing/payment emails uniformly include a dollar sign on the amount, with no intervening space.

The presence or absence of the comma makes no difference to me, but the inconsistency of the $ is making it difficult to use the result in constructing a new filename (do I concatenate with a “$” or not?) or coercing it to a number for later use (“set… as real” throws an error if the $ is there, but stripping the first character of the string removes a digit if the $ isn’t there).

How is “document amount” intended to work?

2

Is the format of the amount also identical after converting the emails to plain text (as only the text matters, not the visible layout)? Or could you send a zipped copy of these emails to cgrunenberg - at - devon-technologies.com? Then I could try to reproduce this over here, thanks.

3

Are the prices represented as links in the emails?

4

The format of the amounts are unchanged when converted to plain text. I have sent you a zip file of four emails.

5

No, just text.