Only numbers
Keeps only the digits in a value and merges them. Use it to reduce a phone number, a card reference, or an account code to bare digits, whatever punctuation and spacing it was stored with.
Syntax
{{onlyNumbers data format culture}}
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| Data | Text | Required | The value to take the digits from. |
| Format | Text | Optional | How the result is written. Your account's default number format is used when you leave it out. |
| Culture | Text | Optional | The culture used to write the result. Your account's default is used when you leave it out. |
Important: Every character that is not a digit is removed, and that includes the decimal point. A value of16.99USmerges as1699, not16.99. Do not use this on an amount of money: it will silently multiply what the reader sees by a hundred.
Note: To tidy up a number without changing its value, use Format number. To change the value, use Round.
Note: A value with no digits at all merges as nothing.
Examples
The examples below are based on the following sample content:
Call us back on {{onlyNumbers Contact.phone}}
A. The contact's phone field has the value (555) 123-4567
Call us back on 5551234567
B. The field has the value 16.99US
1699
The decimal point is a non-digit, so it is removed along with the letters.
C. The field has the value abc
Nothing is merged.