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. For details, check with your Implementation Manager.

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	;,.\/:!?<>~`#%^@(){}&’[]”
Email	;,/:!?\<>~`#%^(){}|&'[]"
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 Australasia	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^()+
AB Corp	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^''&\/?''
AB Corp AU	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^''&\/?''
AB CORP NZ	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^''&\/?''
AllPay (ZEBIT)	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/`'()+
ArrowEye	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/&`'()+
Austria Card	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^'
Borica	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^'
Catalyst	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^'&\/?'
CPI	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^`'
CPI Card Group Canada	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	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äácdéëeíllnöoôrštüúuuýžÄÁCDÉEËÍLLNÓÖOÔRŠTÜÚUUÝŽ!$%&'-+)(./
Gemalto France	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^
Gemalto – DCT	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^
Gemalto Poland	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ-^aAcCeElLnNÓóSsZzZz
Gemalto Singapore	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789&/-''.
GNC	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^+@&-'/
Goldpac	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^'&\/?'
GyD	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/&`'()+
GyD UK	ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-. ‘''
Idemia	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^'+()
Incodia International	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^($£€.
Intaremit	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^
MTL	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^
Morpho Cards	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^'
Nagra ID	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/&`''()+
Nitecrest	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-^''''ßÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØŠÙÚÛÜŸÝŽĄĆČĎĘĹĽŁŃŇŐŔŚȘȚŤŰŹŻäácdæéëeíllnöoøôrštüúuuýžãǎ
Oberthur France	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/`''()+
Placard Vault Payments Solution	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^'
Rosan Finance	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^/&`'
TAG Poland	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^’’’‘’`’
TCT (Thames)	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^'/
TOPPAN	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^'&\/?'
Thredd	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-^''''ßÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØŠÙÚÛÜŸÝŽĄĆČĎĘĹĽŁŃŇŐŔŚȘȚŤŰŹŻäácdæéëeíllnöoøôrštüúuuýžäöüÄÖÜ.-^’,&\/?’
TrueB	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^
Verisoft	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789äöüÄÖÜ.-^
Virtual Only	abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-^''''ßÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØŠÙÚÛÜŸÝŽĄĆČĎĘĹĽŁŃŇŐŔŚȘȚŤŰŹŻäácdæéëeíllnöoøôrštüúuuýžäöüÄÖÜ.-^’&\/?’

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.

!	U+0021	Ö	U+00D6
"	U+0022	Ø	U+00D8
#	U+0023	Ù	U+00D9
$	U+0024	Ú	U+00DA
%	U+0025	Û	U+00DB
&	U+0026	Ü	U+00DC
'	U+0027	Ü	U+00DC
(	U+0028	ß	U+00DF
)	U+0029	à	U+00E0
*	U+002A	á	U+00E1
+	U+002B	â	U+00E2
,	U+002C	ã	U+00E3
-	U+002D	ä	U+00E4
.	U+002E	å	U+00E5
/	U+002F	æ	U+00E6
/	U+002F	ç	U+00E7
:	U+003A	è	U+00E8
;	U+003B	é	U+00E9
<	U+003C	ê	U+00EA
=	U+003D	ë	U+00EB
>	U+003E	ì	U+00EC
?	U+003F	í	U+00ED
?	U+003F	î	U+00EE
@	U+0040	ñ	U+00F1
[	U+005B	ò	U+00F2
\	U+005C	ó	U+00F3
]	U+005D	ô	U+00F4
^	U+005E	õ	U+00F5
_	U+005F	ö	U+00F6
c	U+0063	ù	U+00F9
d	U+0064	ú	U+00FA
e	U+0065	û	U+00FB
l	U+006C	ü	U+00FC
n	U+006E	ý	U+00FD
r	U+0072	ÿ	U+00FF
t	U+0074	Ć	U+0106
u	U+0075	Č	U+010C
|	U+007C	Ď	U+010E
£	U+00A3	Ę	U+0118
¤	U+00A4	Ĺ	U+0139
°	U+00B0	Ľ	U+013D
À	U+00C0	Ł	U+0141
Á	U+00C1	Ń	U+0143
Â	U+00C2	Ň	U+0147
Ã	U+00C3	Ő	U+0150
Ä	U+00C4	Ŕ	U+0154
Å	U+00C5	Ś	U+015A
Å	U+00C5	Š	U+0160
Æ	U+00C6	š	U+0161
Ç	U+00C7	Ť	U+0164
È	U+00C8	Ű	U+0170
É	U+00C9	Ź	U+0179
Ê	U+00CA	Ż	U+017B
Ê	U+00CA	Ž	U+017D
Ë	U+00CB	ž	U+017E
Ì	U+00CC	Ș	U+0218
Í	U+00CD	Ț	U+021A
Î	U+00CE	’	U+2019
Ï	U+00CF	„	U+201E
Ñ	U+00D1	€	U+20AC
Ò	U+00D2	Ö	U+00D6
Ó	U+00D3	Ø	U+00D8
Ô	U+00D4	Ù	U+00D9
Õ	U+00D5	Ú	U+00DA

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, left and right parenthesis (i.e. brackets), spaces 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.

If invalid values such as alphabetic characters, alphanumeric characters or numbers exceeding 15 digits are provided, the service returns Action Code 439.