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

;,.\/!?<>~`#%^@(){}|&’[]”

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äöüÄÖÜ.-^

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:

  • 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.