Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT Text(CSV)
csv text
muhd ramizal
2008-01-28 19:45:23.0
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.0
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.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap