String Cleaning and Approved Characters
Thredd cleans any strings before adding to the database, limiting characters to the ASCII range of 33 to 122. This is aimed at stopping any unexpected characters in the core data for Authorisation, Presentments and Transactions, and to ensure data can be reliably used by EHI, Reporting, Smart Client, Thredd Portal and other systems.
These lists are subject to change over time as printing capabilities and customer requirements change.
Characters Removed from Input Fields
The following special characters are removed from input fields:
|
Field |
Special Characters that will be removed |
|---|---|
|
CardName |
;:!?\<>~#%@{}|[]” |
|
FirstName |
;:!?\<>~#%@{}|[]” |
|
LastName |
;:!?\<>~#%@{}|[]” |
|
EmbossLine4 |
;,\:!?<>~`#%^@(){}|’[]” |
|
Addrl1 |
;:!?\<>~`#%^@{}|[]” |
|
Addrl2 |
;:!?\<>~`#%^@{}|[]” |
|
Addrl3 |
;:!?\<>~`#%^@{}|[]” |
|
City |
;:!?\<>~`#%^@(){}|&[]” |
|
PostCode |
;:!?\<>~`#%^@(){}|&[]” |
|
Country |
;:!?\<>~`#%^@(){}|&[]” |
|
Delv_AddrL1 |
;:!?\<>~`#%^@{}|[]” |
|
Delv_AddrL2 |
;:!?\<>~`#%^@{}|[]” |
|
Delv_AddrL3 |
;:!?\<>~`#%^@{}|[]” |
|
Delv_City |
;:!?\<>~`#%^@(){}|&[]” |
|
Delv_County |
;:!?\<>~`#%^@(){}|&[]” |
|
Delv_PostCode |
;:!?\<>~`#%^@(){}|&[]” |
|
Delv_Country |
;:!?\<>~`#%^@(){}|&[]” |
|
Delv_Code |
;:!?\<>~`#%^@(){}|&[]” |
|
Fulfil1 |
;,/:!?\<>~`#%^(){}|&’[]” |
|
Fulfil2 |
;,/:!?\<>~`#%^(){}|&’[]” |
|
ThermalLine1 |
;:!?\<>~`#%^@(){}|&[]” |
|
ThermalLine2 |
;:!?\<>~`#%^@{}|&[]” |
|
Title |
;:!?\<>~`#%^@(){}|&[]” |
|
ImageId |
;:!?\<>~`#%^@(){}|&[]” |
|
LogoFrontId |
;:!?\<>~`#%^@(){}|&[]” |
|
LogoBackId |
;:!?\<>~`#%^@(){}|&[]” |
|
Mobile |
;,:!?\<>~`#%^@-=*_$??(){}|&’[]” |
|
ExternalRef |
;,.\/:!?<>~`#%^@(){}&’[]” |
|
CustAccount |
;,.\/:!?<>~`#%^@(){}&’[]” |
|
|
;,/:!?\<>~`#%^(){}|&'[]" |
|
Url |
<>&'" |
|
Reason |
;,.\/!?<>~`#%^@(){}|&’[]” |
|
Date fields (e.g. DOB, LocDate) |
;,\/:!?<>~`#%^@+*_$(){}|&'[]" |
|
Other string fields |
;:!?\<>~`#%^@(){}|&[]” |
Card Manufacturer Approved Characters
When submitting the CardName and EmbossName parameters (or FirstName and LastName if CardName is empty), note that the card manufacturer only accepts the following approved characters:
|
Manufacturer |
Allowed Characters |
|---|---|
|
ABNote |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
|
AB Corp |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
AB Corp AU |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
AB CORP NZ |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
AllPay |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/`’,()+ |
|
ArrowEye |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/&`’,()+ |
|
Austria Card |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’ |
|
Borica |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
Catalyst |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
CPI |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^`’ |
|
CPI Card Group |
ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890ÄÅÆÇÉÑÖÜàáâäåæçèéêëìíîïñòóôöùúûü!@#$%^&*()_+-=/\|[]<>?;:’”ÀÁÂÃëÈÊËÌÍÎÏÒÓÔÕÙÚÛãðõœ |
|
CPI Group (UK) |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789($£€.,!?) |
|
DZ |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
|
DigiSEq |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
|
EVRY |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
Exceet |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^&’ |
|
Futurecard |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
|
GEMALTO |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
|
GNC |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^+@&-'/, |
|
Gemalto AU |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
Gemalto Brazil |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
Gemalto Czech Republic |
ABCDEFGHIJKLMNOPQRSTUVWXYZÄÜÖ/+-:;,.-@§D1234567890 |
|
Gemalto – DCT |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
|
Gemalto Poland |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ-^aAcCeElLnNÓóSsZzZz |
|
Gemalto Singapore |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^',&/?' |
|
Goldpac |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
GyD |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/&`’,()+ |
|
GyD UK |
ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-. ‘ |
|
IDEMIA |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/`’,()+ |
|
Intaremit |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
|
MTL |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
|
Morpho |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’ |
|
Nagra ID |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/&`’,()+ |
|
Nitecrest |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-^’ßÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØŠÙÚÛÜŸÝŽĄĆČĎĘĹĽŁŃŇŐŔŚȘȚŤŰŹŻ |
|
Oberthur |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/`’,()+ |
|
Rosan Finance |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’ |
|
TAG |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’’’‘’`’ |
|
TCT |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
TOPPAN |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’,&\/?’ |
|
Thredd |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-^''''ßÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØŠÙÚÛÜŸÝŽĄĆČĎĘĹĽŁŃŇŐŔŚȘȚŤŰŹŻäácdæéëeíllnöoøôrštüúuuýžäöüÄÖÜ.-^’,&\/?’ |
|
TrueB |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
|
Verisoft |
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^ |
Please ensure you use the correct unicode characters supported by your card manufacturer. For example, you should use the straight apostrophe (') which is unicode character U+2019. Do not use the smart apostrophe (’) which is unicode character U+0027.
Replacement of Diacritic Letters
In addition to restricting the characters allowed, Thredd also automatically replaces common diacritic letters with Latin alphabet letters. This applies only to track data used for the manufacturer files.
|
Diacritic Letter |
Classic Latin Alphabet Letter |
|---|---|
|
Á |
A |
|
á |
a |
|
Ä |
A |
|
ä |
a |
|
À |
A |
|
à |
a |
|
 |
A |
|
â |
a |
|
à |
A |
|
ã |
a |
|
Å |
A |
|
å |
a |
|
Ç |
C |
|
ç |
c |
|
É |
E |
|
é |
e |
|
È |
E |
|
è |
e |
|
Ê |
E |
|
ê |
e |
|
Ë |
E |
|
ë |
e |
|
Í |
I |
|
í |
i |
|
Î |
I |
|
î |
i |
|
Ï |
I |
|
ï |
i |
|
Ì |
I |
|
ì |
i |
|
Ñ |
N |
|
ñ |
n |
|
Ó |
O |
|
ó |
o |
|
Ô |
O |
|
ô |
o |
|
Ò |
O |
|
ò |
o |
|
Ö |
O |
|
ö |
o |
|
Õ |
O |
|
õ |
o |
|
Ú |
U |
|
ú |
u |
|
Û |
U |
|
û |
u |
|
Ü |
U |
|
ü |
u |
|
Ù |
U |
|
ù |
u |
|
Ÿ |
Y |
|
ÿ |
y |
|
Ý |
Y |
|
ý |
y |
|
ß |
S |
|
Æ |
AE |
|
æ |
ae |
|
Π|
OE |
|
œ |
oe |
|
Č |
C |
|
č |
c |
|
Ď |
D |
|
ď |
d |
|
Ě |
E |
|
ě |
e |
|
Ĺ |
L |
|
ĺ |
l |
|
Ľ |
L |
|
ľ |
l |
|
Ň |
N |
|
ň |
n |
|
Ő |
O |
|
ő |
o |
|
Ř |
R |
|
ř |
r |
|
Š |
S |
|
š |
s |
|
Ť |
T |
|
ť |
t |
|
Ű |
U |
|
ű |
u |
|
Ů |
U |
|
ů |
u |
|
Ž |
Z |
|
ž |
z |
|
Ø |
O |
|
Ą |
A |
|
ą |
a |
|
Ć |
C |
|
ć |
c |
|
Ę |
E |
|
ę |
e |
|
Ł |
L |
|
ł |
l |
|
Ń |
N |
|
ń |
n |
|
Ø |
O |
|
ø |
o |
|
Ŕ |
R |
|
ŕ |
r |
|
Ś |
S |
|
ś |
s |
|
Ș |
S |
|
ș |
s |
|
Ț |
T |
|
ț |
t |
|
Ź |
Z |
|
ź |
z |
|
Ż |
Z |
|
ż |
z |
Character Support in Web Services Calls
Postcode Permitted Characters
You can use the following characters in the Postcode field:
-
Arabic numerals "0" to "9"
-
letters of the ISO basic Latin alphabet (A-Z, a-z)
-
spaces
-
hyphens(-).
Card Name Permitted Characters
You can use the following characters in the CardName field:
-
abcdefghijklmnopqrstuvwxyz
-
ABCDEFGHIJKLMNOPQRSTUVWXYZ
-
0123456789
-
Some non-english characters i.e. “äöüÄÖÜ”
-
“/” (forward slash)
-
“-“ (hyphen)
-
“^” (caret)
-
“.” (full stop)
-
“ “ (space character)
-
“’” (apostrophe)
If you are using Thredd as your Card Manufacturer, for example, for Virtual cards where an external card manufacturer is not needed, the the CardName field permits the following additional characters in : ^''''ßÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØŠÙÚÛÜŸÝŽĄĆČĎĘĹĽŁŃŇŐŔŚȘȚŤŰŹŻäácdæéëeíllnöoøôrštüúuuýžäöüÄÖÜ.-^’,&\/?’
Processing of Phone Numbers
Thredd processes telephone numbers in web services as follows:
-
Allows up to a maximum of 15 digits.
-
Deletes all special characters, including spaces, left and right parenthesis (i.e. brackets), and hyphens “-“.
-
Deletes all leading non-numeric characters except “+”. Non-leading non-numeric characters (e.g. “-“) are not removed.
-
Depending on the country, the national (domestic/inter-regional within a country) dialling prefix (e.g. single zero for many countries such as the UK, France, Spain, Australia) is dropped and "+" and the IDD (International Direct Dialing) number is prefixed. For example:
-
London, UK: 020 7292 2400 is changed to
+442072922400 -
Lyon, France: 04 72 12 34 56 78 is changed to
+3347212345678 -
Kuala Lumpur, Malaysia: 03 2123 4567 is changed to
+60321234567 -
Mobile number, Spain: 0612 345 678 is changed to
+34612345678 -
Sydney, Australia: 02 7010 1111 is changed to
+61270101111
-
-
If there is a "+" prefix, Thredd checks if the digits which follow match the IDD number of the specified country. If they don't match, nothing is done. If they do match, Thredd checks if the digits which follow match the national dialling prefix (e.g. single zero for many countries such as UK, France, Spain, Australia). If they do match, the national dialling prefix is dropped. For example:
-
London, UK: +44 020 7292 2400 is changed to
+442072922400 -
Lyon, France: +33 04 72 12 34 56 78 is changed to
+3347212345678 -
Kuala Lumpur, Malaysia: +60 03 2123 4567 is changed to
+60321234567 -
Mobile number, Spain: +34 0612 345 678 is changed to
+34612345678 -
Sydney, Australia: +61 02 7010 1111 is changed to
+61270101111
-
-
If there is no leading "+" or national dialling prefix, the phone number is stored as it is.