HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

csv text	muhd ramizal	2008-01-28 19:45:23
hi! i just bought the csv driver. however it incorrectly separate the field data in the sample below: "KP","KODSEK","NAMA","TLAHIR","ALAMAT","ALAMAT2","POSKOD","BANDAR","NEGERI","TELEFON","NAMAWARIS","KPWARIS","DARJAH","NKELAS","JANTINA","KAUM","WARGA","NEGASAL","AGAMA","PBAPA","PIBU","PJAGA","JUMLAH","KBAPA","KIBU","KJAGA","JARAK","BILAHLI","BILBELAJAR","YATIM","STATUSJAGA","BILSPBT","BILRMT","BILASRAMA","PEKAN","SAR","CATATAN","KEMASKINI","PERKAPITA","P1","P2","UPSR","PMR","SPM","SPBT","RMT","PSS","BIASISWA","JENISBIA","TUISYEN","KWAPM1","KWAPM2","KWAPM3","KWAPM4","OKU","TGASRAMA","ASRAMA","UNI","JUNI","KEL","JKEL","SUK","JSUK","KHIDMAT1","KHIDMAT2" "880920045171","MRA2125","AHMAD MUKHSIN BIN ZAZAM",20/09/1988 0:00:00,"KM 15.5 KG. SERI MINYAK, UMBAI, 77300 MERLIMAU, MELAKA",,"77300","MERLIMAU","04","0176642692","ZAZAM BIN AHMAD","500815045439","T6R","SYARIAH","L","01","W",,"01",3000.00,0.00,0.00,3000.00,"P56","X01","X00",15,9,4,"T","J1",3,0,0,,"T",,08/04/2007 0:00:00,333.33,0.00,0.00,"2A","6A","2A","T","T","T","T","B0","T","T","T","T","T","T","T","A0","A05","AB","B01","AB","F05","AB","P99","P00" "890110035130","MRA2125","SITI RAWAIDA BTE ROSLI",10/01/1989 0:00:00,"NO. 27, JLN. PANDAN JAYA, TMN. PANDAN JAYA",,"75250","MELAKA","04","0176060534","ROSLI BIN MANSOR","RF72276","T6R","SYARIAH","P","01","W",,"01",2075.85,0.00,0.00,2075.85,"P59","X01","X00",7,7,4,"T","J1",3,0,0,,"T",,08/05/2007 0:00:00,296.55,0.00,0.00,"3A","4A","3A","T","T","T","T","B0","T","T","T","T","T","T","T","A0","A04","BN","B99","AJ","F01","AB","P03","P12" "890215045132","MRA2125","ROSHAZMI BT. MOHAMED RASIP",15/02/1989 0:00:00,"NO. 18, JLN DESA MOLEK 12, TAMAN DESA MOLEK",,"75460","MELAKA","04","0062680143","MOHAMED RASIP B. SAMAT","470310015707","T6R","SYARIAH","P","01","W",,"01",450.55,0.00,0.00,450.55,"P56","X01","X00",24,7,1,"T","J3",0,0,1,,"T",,07/03/2007 0:00:00,64.36,0.00,0.00,"3A","5A","3A","T","T","T","T","B0","T","T","T","T","T","T","Y","A2","A99","AB","B99","AB","F05","AB","P99","P00" "890217045304","MRA2125","NURLIYANA BT ASMANI",17/02/1989 0:00:00,"NO. 3, JLN. BERTAM PERDANA 4, TAMAN PERTAM PERDANA,",,"75200","PULAU GADONG","04","0176722057","ASMANI BIN SENIN","RF102451","T6R","SYARIAH","P","01","W",,"01",1598.71,0.00,0.00,1598.71,"P59","X01","X00",15,6,4,"T","J1",3,0,1,,"T",,07/08/2007 0:00:00,266.45,0.00,0.00,"3A","4A","2A","T","T","T","T","B0","T","T","T","T","T","T","Y","A2","A04","AB","B01","AB","F01","AB","P99","P99" "890313305006","MRA2125","NORHAFIZAH BTE JAAFAR",13/03/1989 0:00:00,"KM 16, SOLOK SEROMPONG, KG. TEHEL",,"77200","BEMBAN","04","0195768236","JAAFAR BIN HAMZAH","441028045205","T6R","SYARIAH","P","01","W",,"01",599.70,0.00,0.00,599.70,"P56","X01","X00",28,11,5,"T","J1",2,0,0,,"T",,08/04/2007 0:00:00,54.51,0.00,0.00,"4A","-","2A","T","T","T","T","B0","T","T","T","T","T","T","T","A0","A05","AB","B01","AB","F01","AB","P99","P00" where the first row is the field/column names in the csv file i hav set the properties as below properties.put("_CSV_Header","true"); properties.put("_CSV_Separator",","); properties.put("_CSV_Quoter","\""); con1 = DriverManager.getConnection("jdbc:csv://///TEST.TXT, properties); could u help on this for yr info ms excel csv import, sql server csv import managed to get it right. 2ndly, i tried to use rs.getString("KP")... error 'column not found!' comes out. thanks remy
Re:csv text	HXTT Support	2008-01-28 21:59:11
Passed test with your sample, "select KP,* from test;" will return: KP BIGINT 12 0 0 KP BIGINT 12 0 0 KODSEK LONGVARCHAR 7 0 0 NAMA LONGVARCHAR 26 0 0 TLAHIR TIMESTAMP 18 0 0 ALAMAT LONGVARCHAR 54 0 0 ALAMAT2 LONGVARCHAR 0 0 0 POSKOD INTEGER 5 10 0 BANDAR LONGVARCHAR 12 0 0 NEGERI INTEGER 2 10 0 TELEFON INTEGER 10 10 0 NAMAWARIS LONGVARCHAR 22 0 0 KPWARIS LONGVARCHAR 12 0 0 DARJAH LONGVARCHAR 3 0 0 NKELAS LONGVARCHAR 7 0 0 JANTINA LONGVARCHAR 1 0 0 KAUM INTEGER 2 10 0 WARGA LONGVARCHAR 1 0 0 NEGASAL LONGVARCHAR 0 0 0 AGAMA INTEGER 2 10 0 PBAPA DOUBLE 7 16 16 PIBU DOUBLE 4 16 16 PJAGA DOUBLE 4 16 16 JUMLAH DOUBLE 7 16 16 KBAPA LONGVARCHAR 3 0 0 KIBU LONGVARCHAR 3 0 0 KJAGA LONGVARCHAR 3 0 0 JARAK INTEGER 2 10 0 BILAHLI INTEGER 2 10 0 BILBELAJAR INTEGER 1 10 0 YATIM LONGVARCHAR 1 0 0 STATUSJAGA LONGVARCHAR 2 0 0 BILSPBT INTEGER 1 10 0 BILRMT INTEGER 1 10 0 BILASRAMA INTEGER 1 10 0 PEKAN LONGVARCHAR 0 0 0 SAR LONGVARCHAR 1 0 0 CATATAN LONGVARCHAR 0 0 0 KEMASKINI TIMESTAMP 18 0 0 PERKAPITA DOUBLE 6 16 16 P1 DOUBLE 4 16 16 P2 DOUBLE 4 16 16 UPSR LONGVARCHAR 2 0 0 PMR LONGVARCHAR 2 0 0 SPM LONGVARCHAR 2 0 0 SPBT LONGVARCHAR 1 0 0 RMT LONGVARCHAR 1 0 0 PSS LONGVARCHAR 1 0 0 BIASISWA LONGVARCHAR 1 0 0 JENISBIA LONGVARCHAR 2 0 0 TUISYEN LONGVARCHAR 1 0 0 KWAPM1 LONGVARCHAR 1 0 0 KWAPM2 LONGVARCHAR 1 0 0 KWAPM3 LONGVARCHAR 1 0 0 KWAPM4 LONGVARCHAR 1 0 0 OKU LONGVARCHAR 1 0 0 TGASRAMA LONGVARCHAR 1 0 0 ASRAMA LONGVARCHAR 2 0 0 UNI LONGVARCHAR 3 0 0 JUNI LONGVARCHAR 2 0 0 KEL LONGVARCHAR 3 0 0 JKEL LONGVARCHAR 2 0 0 SUK LONGVARCHAR 3 0 0 JSUK LONGVARCHAR 2 0 0 KHIDMAT1 LONGVARCHAR 3 0 0 KHIDMAT2 LONGVARCHAR 3 0 0 880920045171 880920045171 MRA2125 AHMAD MUKHSIN BIN ZAZAM 1988-09-20 00:00:00.0 KM 15.5 KG. SERI MINYAK, UMBAI, 77300 MERLIMAU, MELAKA null 77300 MERLIMAU 4 176642692 ZAZAM BIN AHMAD 500815045439 T6R SYARIAH L 1 W null 1 3000.0 0.0 0.0 3000.0 P56 X01 X00 15 9 4 T J1 3 0 0 null T null 2007-08-04 00:00:00.0 333.33 0.0 0.0 2A 6A 2A T T T T B0 T T T T T T T A0 A05 AB B01 AB F05 AB P99 P00 890110035130 890110035130 MRA2125 SITI RAWAIDA BTE ROSLI 1989-10-01 00:00:00.0 NO. 27, JLN. PANDAN JAYA, TMN. PANDAN JAYA null 75250 MELAKA 4 176060534 ROSLI BIN MANSOR RF72276 T6R SYARIAH P 1 W null 1 2075.85 0.0 0.0 2075.85 P59 X01 X00 7 7 4 T J1 3 0 0 null T null 2007-08-05 00:00:00.0 296.55 0.0 0.0 3A 4A 3A T T T T B0 T T T T T T T A0 A04 BN B99 AJ F01 AB P03 P12 890215045132 890215045132 MRA2125 ROSHAZMI BT. MOHAMED RASIP 1989-02-15 00:00:00.0 NO. 18, JLN DESA MOLEK 12, TAMAN DESA MOLEK null 75460 MELAKA 4 62680143 MOHAMED RASIP B. SAMAT 470310015707 T6R SYARIAH P 1 W null 1 450.55 0.0 0.0 450.55 P56 X01 X00 24 7 1 T J3 0 0 1 null T null 2007-07-03 00:00:00.0 64.36 0.0 0.0 3A 5A 3A T T T T B0 T T T T T T Y A2 A99 AB B99 AB F05 AB P99 P00 890217045304 890217045304 MRA2125 NURLIYANA BT ASMANI 1989-02-17 00:00:00.0 NO. 3, JLN. BERTAM PERDANA 4, TAMAN PERTAM PERDANA, null 75200 PULAU GADONG 4 176722057 ASMANI BIN SENIN RF102451 T6R SYARIAH P 1 W null 1 1598.71 0.0 0.0 1598.71 P59 X01 X00 15 6 4 T J1 3 0 1 null T null 2007-07-08 00:00:00.0 266.45 0.0 0.0 3A 4A 2A T T T T B0 T T T T T T Y A2 A04 AB B01 AB F01 AB P99 P99 890313305006 890313305006 MRA2125 NORHAFIZAH BTE JAAFAR 1989-03-13 00:00:00.0 KM 16, SOLOK SEROMPONG, KG. TEHEL null 77200 BEMBAN 4 195768236 JAAFAR BIN HAMZAH 441028045205 T6R SYARIAH P 1 W null 1 599.7 0.0 0.0 599.7 P56 X01 X00 28 11 5 T J1 2 0 0 null T null 2007-08-04 00:00:00.0 54.51 0.0 0.0 4A - 2A T T T T B0 T T T T T T T A0 A05 AB B01 AB F01 AB P99 P00 The total row number of resultset: 5 Please send us your code and txt sample so that we can find what's your issue.

Email:

webmaster@hxtt.com