UnitTest( csv.asp )

Output

(Recorset) [(Record) {"id": (String) "1","firstname": (String) "Mário"},(Record) {"id": (String) "2","firstname": (String) "Mitika"},(Record) {"id": (String) "3","firstname": (String) "João"},(Record) {"id": (String) "4","firstname": (String) "Myrian"},(Record) {"id": (String) "5","firstname": (String) "Fábio"},(Record) {"id": (String) "6","firstname": (String) "Liza"},(Record) {"id": (String) "7","firstname": (String) "Momy"},(Record) {"id": (String) "8","firstname": (String) "Kuri"},(Record) {"id": (String) "9","firstname": (String) "Complex line
with vbCrLf and quote (") example"}]


(Recorset) [(Record) {"F1": (String) "1","F2": (String) "Mário"},(Record) {"F1": (String) "2","F2": (String) "Mitika"},(Record) {"F1": (String) "3","F2": (String) "João"},(Record) {"F1": (String) "4","F2": (String) "Myrian"},(Record) {"F1": (String) "5","F2": (String) "Fábio"},(Record) {"F1": (String) "6","F2": (String) "Liza"},(Record) {"F1": (String) "7","F2": (String) "Momy"},(Record) {"F1": (String) "8","F2": (String) "Kuri"},(Record) {"F1": (String) "9","F2": (String) "Complex line
with vbCrLf and quote (") example"}]


(Recorset) [(Record) {"id,firstname": (String) "1,Foo"},(Record) {"id,firstname": (String) "2,Bar"}]


"id","idSequential","type","line_1","line_2","line_3","postcode","city","state_province_region","country","clobCF","clobChildren","dtIns","dtUpd","owner"
"32","5","Address (Work)","Avenida Jaime Torres, 265","","Jardim Popular","03670-000","São Paulo","SP","Brasil","{}","[]","1/3/2014 10:03:00 PM","1/3/2014 10:03:00 PM","EVOLVED_FILLER"
"44","6","Address","Rua Miller, 356","","Brás","03011-010","São Paulo","SP","Brasil","{}","[]","1/3/2014 10:03:00 PM","6/25/2014 12:15:00 PM","nagaozen"
"51","7","Address","Rua Miller, 356","","Brás","03011-010","São Paulo","SP","Brasil","{}","[]","1/3/2014 10:03:00 PM","6/25/2014 12:15:00 PM","nagaozen"
"58","8","Address","Rua Miller, 356","","Brás","03011-010","São Paulo","SP","Brasil","{}","[]","1/3/2014 10:03:00 PM","6/2/2014 4:23:00 PM","nagaozen"
"63","9","Address","Rua Miller, 356","","Brás","03011-010","São Paulo","SP","Brasil","{}","[]","1/3/2014 10:03:00 PM","1/3/2014 10:03:00 PM","EVOLVED_FILLER"
"179","11","Address","Avenida Jaime Torres, 273","","Jardim Popular","03670-000","São Paulo","SP","Brasil","{}","[]","1/7/2014 6:18:00 PM","1/7/2014 6:18:00 PM","nagaozen"
"184","12","Address","Rua Augusta, 183","Torre 4B, Apto 111","Vila Augusta","07025-130","Guarulhos","SP","Brasil","{}","[]","1/8/2014 2:14:00 PM","1/8/2014 2:14:00 PM","nagaozen"
"198","13","Address","Rua Miller, 356","","Brás","03011-010","São Paulo","SP","Brasil","{}","[]","1/10/2014 9:57:00 AM","1/10/2014 9:57:00 AM","nagaozen"
"203","14","Address","Rua Miller, 356","","Brás","03011-010","São Paulo","SP","Brasil","{}","[]","1/27/2014 12:44:00 PM","1/27/2014 12:44:00 PM","nagaozen"
"211","16","Address","Rua Augusta, 183","Torre 4B, Apto 111","Vila Augusta","07025-130","Guarulhos","SP","Brasil","{}","[]","1/28/2014 4:20:00 PM","1/28/2014 4:20:00 PM","nagaozen"
"222","17","Address","Rua Augusta, 183","","Vila Augusta","07025-130","Guarulhos","SP","Brasil","{}","[]","1/29/2014 5:08:00 PM","2/14/2014 1:44:00 PM","nagaozen"
"4923","18","Address","Avenida Jaime Torres, 273","","Jardim Popular","03670-000","São Paulo","SP","Brasil","{}","[]","3/13/2014 12:20:00 PM","4/4/2014 11:14:00 AM","nagaozen"
"24378","5820","Address","RUA ERNESTO SIVORI, 09","","VILA SANTANA","03613-130","Sao Paulo","SP","Brasil","{}","[]","5/23/2014 3:30:00 AM","5/23/2014 3:30:00 AM","nagaozen"
"24382","5821","Address","RUA ALBA CANDIDA PEREIRA DA SILVA, 1881-A","","JARDIM ALVORADA","79610-280","TRES LAGOAS","MS","Brasil","{}","[]","5/23/2014 3:34:00 AM","5/23/2014 3:34:00 AM","nagaozen"
"24386","5822","Address","RUA - VEREADOR SERGIO LEOPOLDINO ALVES, 876","","DISTRITO - INDUSTRIAL","13456-166","Santa Barbara DOeste","SP","Brasil","{}","[]","5/23/2014 10:08:00 AM","5/23/2014 10:08:00 AM","nagaozen"
"24390","5823","Address","RUA PROGRESSO, 4172","","PROGRESSO","89027-000","BLUMENAU","SC","Brasil","{}","[]","5/23/2014 10:12:00 AM","5/23/2014 10:12:00 AM","nagaozen"
"24394","5824","Address","ROD. ANTONIO HEIL, n.7550","","LIMOEIRO","88352-502","BRUSQUE","SC","Brasil","{}","[]","5/23/2014 10:46:00 AM","5/23/2014 10:46:00 AM","nagaozen"
"24398","5825","Address","R SIMPLICIANO DIAS DE OLIVEIRA, 180","","SAO BENEDITO","37564-000","BORDA DA MATA","MG","Brasil","{}","[]","5/23/2014 10:46:00 AM","5/23/2014 10:46:00 AM","nagaozen"
"24402","5826","Address","RUA ALBA CANDIDA PEREIRA DA SILVA, 1881-A","","JARDIM ALVORADA","79610-280","TRES LAGOAS","MS","Brasil","{}","[]","5/23/2014 11:51:00 AM","5/23/2014 11:51:00 AM","nagaozen"
"24406","5827","Address","ROD. ANTONIO HEIL, n.7550","","LIMOEIRO","88352-502","BRUSQUE","SC","Brasil","{}","[]","5/23/2014 11:51:00 AM","5/23/2014 11:51:00 AM","nagaozen"
"24410","5828","Address","R SIMPLICIANO DIAS DE OLIVEIRA, 180","","SAO BENEDITO","37564-000","BORDA DA MATA","MG","Brasil","{}","[]","5/23/2014 11:51:00 AM","5/23/2014 11:51:00 AM","nagaozen"
"24414","5829","Address","RUA ERNESTO SIVORI, 09","","VILA SANTANA","03613-130","Sao Paulo","SP","Brasil","{}","[]","5/23/2014 11:53:00 AM","5/23/2014 11:53:00 AM","nagaozen"
"24421","5830","Address","RUA PROGRESSO, 4172","","PROGRESSO","89027-000","BLUMENAU","SC","Brasil","{}","[]","5/27/2014 6:03:00 PM","5/27/2014 6:03:00 PM","nagaozen"
"24425","5831","Address","RUA - VEREADOR SERGIO LEOPOLDINO ALVES, 876","","DISTRITO - INDUSTRIAL","13456-166","Santa Barbara DOeste","SP","Brasil","{}","[]","5/27/2014 6:10:00 PM","5/27/2014 6:10:00 PM","nagaozen"
"24707","5834","Address","Rua Barão de Ladário, 670","ALA MEGA, LOJA 171","Brás","03010-000","São Paulo","SP","Brasil","{}","[]","5/30/2014 11:01:00 AM","6/2/2014 7:44:00 PM","nagaozen"
"24714","5835","Address","Rua Barão de Ladário, 670","ALA MEGA, LOJA 171","Brás","03010-000","São Paulo","SP","Brasil","{}","[]","5/30/2014 11:01:00 AM","5/30/2014 11:01:00 AM","nagaozen"
"24733","5836","Address","Rua Júlio Ribeiro, 243","ALA POLO, LOJA 325/326","Brás","03010-030","São Paulo","SP","Brasil","{}","[]","6/6/2014 11:06:00 AM","6/6/2014 11:07:00 AM","nagaozen"
"24740","5837","Address","Rua Júlio Ribeiro, 243","ALA POLO, LOJA 325/326","Brás","03010-030","São Paulo","SP","Brasil","{}","[]","6/6/2014 11:06:00 AM","6/6/2014 11:06:00 AM","nagaozen"
"24784","5838","Address","Rua Augusta, 183","Torre 4B, Apto 111","Vila Augusta","07025-130","Guarulhos","SP","Brasil","{}","[]","6/16/2014 5:17:00 PM","3/6/2015 5:48:00 PM","nagaozen"
"24789","5839","Address","Av Torquato Tapajos, 7200","Km 12","Colonia Terra Nova","69093-415","Manaus","AM","Brasil","{}","[]","6/19/2014 9:02:00 PM","6/19/2014 9:02:00 PM","nagaozen"
"24803","5840","Address","Rua Iracema Lucas, 100","","Distr. Industrial","13280-000","Vinhedo","SP","Brasil","{}","[]","6/24/2014 11:36:00 AM","6/24/2014 11:36:00 AM","nagaozen"
"24856","5841","Address","Rua Miller, 356","","Brás","03011-010","São Paulo","SP","Brasil","{}","[]","6/27/2014 1:58:00 AM","6/27/2014 1:58:00 AM","nagaozen"
"24875","5842","Address","Rod Pres. Tancredo de Almeira Neves","Km 34","","07700-000","Caieiras","SP","Brasil","{}","[]","6/27/2014 10:29:00 AM","6/27/2014 10:29:00 AM","nagaozen"
"25146","5844","Address","Rua Sublimação, 33","225","Jardim Japão","02123-060","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25153","5845","Address","Alameda Rio Preto","353","Tamboré","06460-050","Barueri","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25158","5846","Address","Avenida João Bassi","","Jardim Presidente Dutra","07172-440","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25162","5847","Address","Rua Engenheiro Albert Leimer","538","Parque Industrial do Jardim São Geraldo","07140-020","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25166","5848","Address","Rua Soldado Benedito Patrício","100","Parque Novo Mundo","02176-040","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25170","5849","Address","Rodovia Presidente Dutra","KM 228.1","Várzea do Palácio - Jardim Sta Francisca","07034-010","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25179","5850","Address","Rua Endres","1165","Vila Endres","07043-000","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25184","5851","Address","Rua Nestor de Holanda","140","Jardim Andaraí-Vila Maria","02166-060","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25186","5852","Address","Viela Urga","144","Vila Nova Bonsucesso","07175-332","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25193","5853","Address","Rua Amazonas da Silva","55","Vila Guilherme","02051-000","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25195","5854","Address","Avenida Nossa Senhora de Fátima","321","Cidade Aracilia Km 206 Dutra","07250-060","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25202","5855","Address","Rua Joaquim Geraldo","Qd 5 Box 7 Terminal De Cargas Fernão Dias","Vila Sabrina","02162-030","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25204","5856","Address","Avenida Justino de Maio","441","Cidade Industrial Satélite de São Paulo","07222-000","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25208","5857","Address","Rua Soldado Antônio Aparecido","10","Parque Novo Mundo","02187-020","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25213","5858","Address","Rua Bela Vista do Paraíso","1782","Jardim Novo Portugal","07171-000","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25220","5859","Address","Avenida Guinle","1087","Cidade Industrial Satélite  Cumbica","07221-070","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25222","5860","Address","Rua Miguel Mentem","500","Vila Guilherme","02050-010","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25228","5861","Address","Rua Canindé","317","Canindé","03033-000","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25232","5862","Address","Avenida Aníbal Martins","370","Jardim Bela Vista","07132-550","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25234","5863","Address","Avenida Papa João Paulo I","6967","Bom Sucesso","07174-005","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25239","5864","Address","Rua Cabo Eliseu Pinhal","179","Parque Novo Mundo","02187-000","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25245","5865","Address","Rua Cecília Roizen","888","Cidade Industrial Satélite de São Paulo","07222-020","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25249","5866","Address","Rua Almerim","100 Galpão 5/6","Cidade Tupinambá","07263-190","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25257","5867","Address","Avenida João Bassi","65","Jardim Presidente Dutra","07172-440","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25262","5868","Address","Rua Soldado José Reymão","105","Parque Novo Mundo","02178-040","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25266","5869","Address","Rua Engenheiro Albert Leimer","1022","Parque Industrial do Jardim São Geraldo","07140-020","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25270","5870","Address","Rua João Pedro Blumenthal","105","Cumbica","07224-150","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25280","5871","Address","Rua Santa Vitória","321","Cidade Industrial Satélite -Cumbica","07223-120","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25282","5872","Address","Rua Umbuzeiro","24","Cidade Industrial Satélite -Cumbica","07224-010","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25290","5873","Address","Rua Major Marcelino","200","Brás","03025-020","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25292","5874","Address","Avenida Serra Branca","365","Cidade Industrial Satélite -Cumbica","07224-050","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25298","5875","Address","R.DR.RUBENS GOMES BUENO","383","SANTO AMARO ","00000-000","SÃO PAULO","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25302","5876","Address","AV.DOS REMÉDIOS","2246","JARDIM MARISA","00000-000","SÃO PAULO ","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25304","5877","Address","AV.JAGUARÉ","621","JAGUARÉ","00000-000","SÃO PAULO ","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25308","5878","Address","AV. TUCUNARÉ","818"," TAMBORÉ","00000-000","BARUERI","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25312","5879","Address","R.SANTA VITÓRIA","500","CUMBICA","00000-000","GUARULHOS","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25316","5880","Address","R.ALBINO JOSÉ FREIXEDA","123","PRESIDENTE ALTINO","00000-000","OSASCO","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25320","5881","Address","RUA 2º TTE. AVIADOR A.C. PAULA 22","22","CUMBICA","00000-000","GUARULHOS","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25324","5882","Address","R.CEL. BENTO BICUDO","90","LAPA","00000-000","SÃO PAULO","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25328","5883","Address","R.GIANCARLO VESTRI, 1258 CÚMBICA","1258","CUMBICA","00000-000","GUARILHOS","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25332","5884","Address","AV. LINDOMAR GOMES DE OLIVEIRA","956","CUMBICA","00000-000","GUARULHOS","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25336","5885","Address","R.SANTA RITA","1003","PARI","00000-000","SÃO PAULO","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25340","5886","Address","R.HUMBERTO DE CAMPOS,233-JD.MARAVIL","233","JARDIM MARAVIL","00000-000","DIADEMA","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25344","5887","Address","Avenida João Bassi","368","Jardim Presidente Dutra","07172-440","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25350","5888","Address","Rua Domingos Pacheco (TERMINAL DE CARGAS) ","QUADRA.04 B.03 E 04","Jardim Julieta","02162-020","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25355","5889","Address","Rua Ventura Rangel","168","Vila Carbone","02752-050","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25360","5890","Address","Rua Cabo Eliseu Pinhal","237","Parque Novo Mundo","02187-000","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25364","5891","Address","Rua Cecília Roizen","903 BOX 02","Cidade Industrial Satélite de São Paulo","07222-020","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25368","5892","Address","Rua Castor","51","SÃO  MATEUS","08340-120","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25372","5893","Address","Praça Senador Salgado Filho","S/N","Centro","20021-340","Rio de Janeiro","RJ","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25376","5894","Address","Rua Amambaí","1077","Vila Maria","02115-002","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25380","5895","Address","Rua Salvador Rodrigues Prado","200","Parque Novo Mundo","02190-050","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25384","5896","Address","Rua Bela Vista do Paraíso","1782","Jardim Presidente Dutra","07171-000","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25394","5897","Address","Rua Bela Vista do Paraíso","1782","Jardim Presidente Dutra","07171-000","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25396","5898","Address","Viela Urga","557","Vila Nova Bonsucesso","07175-332","Guarulhos","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"25403","5899","Address","Avenida Alexandre Colares","340","Parque Anhangüera","05106-000","São Paulo","SP","Brasil","{}","[]","7/17/2014 12:16:00 PM","7/17/2014 12:16:00 PM","nagaozen"
"27792","5902","Address","Rua Augusta, 183","Torre 4B, Apto 111","Vila Augusta","07025-130","Guarulhos","SP","Brasil","{}","[]","12/11/2014 3:45:00 PM","12/11/2014 3:45:00 PM","nagaozen"

Sources

/axe-ut/csv.unit.test.asp

<!--#include virtual="/lib/unit-tests.asp"-->
<!--#include virtual="/lib/axe/classes/Parsers/csv.asp"-->
<!--#include virtual="/lib/axe/classes/Utilities/stringbuilder.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xml:lang="en">
    <head>
        <title>AXE - Unit Test - CSV</title>
        <!--// meta tags //-->
        <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
        <!--// link tags //-->
        <link rel="stylesheet" type="text/css" media="screen" href="/lib/unit-tests.css" />
    </head>
    <body>
        <div id="container">
            <div id="container-hd">
                <h1>UnitTest( csv.asp )</h1>
            </div>
            <div id="container-bd">
 
<h2>Output</h2>
<div class="code"><pre><%
 
dim Parser, Data
 
set Parser = new CSV
Parser.writablesPath = Server.mapPath("/cache/")
Parser.charset   = "UTF-8"
Parser.codepage  = 65001
Parser.separator = ","
 
set Data = Parser.fromFile( Server.mapPath("csv.example.csv"), true )
Response.write( dump(Data) )
Data.close()
set Data = nothing
 
set Parser = nothing
 
Response.write( vbNewline )
Response.write( vbNewline )
Response.write( vbNewline )
 
set Parser = new CSV
Parser.writablesPath = Server.mapPath("/cache/")
Parser.charset   = "UTF-8"
Parser.codepage  = 65001
Parser.separator = ";"
 
set Data = Parser.fromFile( Server.mapPath("csv.example_no_header.csv"), false )
Response.write( dump(Data) )
Data.close()
set Data = nothing
 
set Parser = nothing
 
Response.write( vbNewline )
Response.write( vbNewline )
Response.write( vbNewline )
 
set Parser = new CSV
Parser.writablesPath = Server.mapPath("/cache/")
Parser.charset   = "UTF-8"
Parser.codepage  = 65001
Parser.separator = ";"
 
set Data = Parser.fromString( join(array( _
    "id,firstname", _
    "1,Foo", _
    "2,Bar" _
), vbCrLf), true )
Response.write( dump(Data) )
Data.close()
set Data = nothing
 
set Parser = nothing
 
Response.write( vbNewline )
Response.write( vbNewline )
Response.write( vbNewline )
 
dim Conn, Rs
 
set Conn = Server.createObject("ADODB.Connection")
Conn.open("Provider=SQLOLEDB; Data Source=192.168.0.112; Initial Catalog=sunny_erp; User Id=sasunny; Password=asdasd;")
 
set Rs = Conn.execute("SELECT * FROM addresses")
 
set Parser = new CSV
Parser.writablesPath = Server.mapPath("/cache/")
Response.write( Parser.toString(Rs) )
set Parser = nothing
 
Rs.close()
set Rs = nothing
 
Conn.close()
set Conn = nothing
 
%></pre></div>
 
            </div>
            <div id="container-ft">
                <h2>Sources</h2>
                <h3><%= Request.ServerVariables("SCRIPT_NAME") %></h3>
                <div class="code"><%= geshify( loadTextFile( Server.mapPath( Request.ServerVariables("SCRIPT_NAME") ) ), "asp" ) %></div>
            </div>
        </div>
        <!--// javascript tags //-->
    </body>
</html>