alsimoes
Follow
Geek, hobbyist developer, sometimes angry, sometimes happy, refactoring life and embracing the changes. Full time project manager!
- São Paulo, Brasil
- https://twitter.com/alsimoes
- @alsimoes
Highlights
- Pro
Pinned Loading
-
-
rci
rci Public[INCOMPLETE] Application for indexing and control of multiple copies of files on removable devices.
Python
-
-
SQL code to format CPF/CNPJ
SQL code to format CPF/CNPJ 1,CASE
2WHEN LEN([nr_cnpj]) = 10 THEN SUBSTRING([NR_CNPJ],1,2) + '.' + SUBSTRING([NR_CNPJ],3,3) + '.' + SUBSTRING([NR_CNPJ],6,3) + '-' + SUBSTRING([NR_CNPJ],9,2)
3WHEN LEN([nr_cnpj]) = 11 THEN SUBSTRING([NR_CNPJ],1,3) + '.' + SUBSTRING([NR_CNPJ],4,3) + '.' + SUBSTRING([NR_CNPJ],7,3) + '-' + SUBSTRING([NR_CNPJ],10,2)
4WHEN LEN([nr_cnpj]) = 12 THEN '00.' + SUBSTRING([NR_CNPJ],1,3) + '.' + SUBSTRING([NR_CNPJ],4,3) + '/' + SUBSTRING([NR_CNPJ],7,4) + '-' + SUBSTRING([NR_CNPJ],11,2)
5WHEN LEN([nr_cnpj]) = 13 THEN '0' + SUBSTRING([NR_CNPJ],1,1) + '.' + SUBSTRING([NR_CNPJ],2,3) + '.' + SUBSTRING([NR_CNPJ],5,3) + '/' + SUBSTRING([NR_CNPJ],8,4) + '-' + SUBSTRING([NR_CNPJ],12,2)
Something went wrong, please refresh the page to try again.
If the problem persists, check the GitHub status page or contact support.
If the problem persists, check the GitHub status page or contact support.