SAS Quality Knowledge Base for Contact Information 27

ID Number (CNPJ) (Electronic)

Standardization Definition

ID Number (CNPJ) (Electronic)
Description The ID Number (CNPJ) (Electronic) standardization definition standardizes the Cadastro Nacional de Pessoas Jurídicas and removes all non-numeric characters.
Examples Input Output
12.345.678/9012-34 12345678901234
12-345-678-9012-34 12345678901234
CNPJ:12345678901234 12345678901234
Cadastro Nacional de Pessoas Juridicas -- 12345678901234 12345678901234
Gol Linhas Aéreas: 12.345.678/9012-34 12345678901234
12.345.678/9012-34 (informações adicionais) 12345678901234
99999999 00000099999999
999999999999 00999999999999
0000012345678901234 12345678901234
Remarks Pads input that is less than 14 digits with leading 0s. Removes excessive leading 0s.