Terima kasih atas masukan dari para jugger smua, tapi skarang saya ada masalah
saat pemanggilan data dari txt file dimana isi dari txt file tersebut adalah :
d2;Marketing;Finance;Finance Head;Kantor Pusat;
d2;Marketing;Acct-Tax;Account Receivable;Kantor Pusat;
d2;Marketing;Acct-Tax;A
pake REGEX
CMIIW
--- On Wed, 11/26/08, Hendra Sukma <[EMAIL PROTECTED]> wrote:
> From: Hendra Sukma <[EMAIL PROTECTED]>
> Subject: [JUG-Indonesia] Still how to read data
> To: "jug JAVA" , "netbeans JAVA" <[EMAIL
> PROTECTED]>
> Date: Wedn
pakai Regex aja, jadi setelah line
// d2;Marketing;Acct-Tax;Account Receivable;Kantor Pusat;
Regex =
(\\p{Alnum}{1,});(\\p{Alpha}{1,0});(\\p{Graph}{1,});(\\p{Alpha}{1,0});(\\p{Alpha}{1,0});
2008/11/27 Hendra Sukma <[EMAIL PROTECTED]>
> Terima kasih atas masukan dari para jugger smua, tapi s
ng sih. TERIMA KASIH BANYAK ATAS BANTUANNYA
--- Pada Kam, 27/11/08, Yogi Eka H. <[EMAIL PROTECTED]> menulis:
Dari: Yogi Eka H. <[EMAIL PROTECTED]>
Topik: Re: [JUG-Indonesia] Still how to read data
Kepada: jug-indonesia@yahoogroups.com
Tanggal: Kamis, 27 November, 2008, 9:56 AM
paling simple ambil tiap line trus bisa di-split.. dan hasilnya udah berupa
array
String
[]*split
*(String regex)
Splits this string around matches of the given regular expression.
tapi mesti ada asumsi.. urutan data konsisten dan tidak ada titik koma di
dalem data.. kalo di dalem d
Coba lihat di :
http://pintar-java.blogspot.com/2008/06/regular-expression-di-java.html
2008/11/27 Hendra Sukma <[EMAIL PROTECTED]>
> Mas gimana cara penggunannya, mas data " d2;Marketing; Acct-Tax;
> Account Receivable;Kantor Pusat; " ini data yg berhasil saya baca dari file
> txt(divisi.tx
onPane.showMessageDialog(null,strLine);
}
//Close the input stream
in.close();
}catch (Exception e){//Catch exception if any
JOptionPane.showMessageDialog(null,"Error: " + e.getMessage());
}
--- Pada Kam, 27/11/08, Feris Thia <[EMAIL PROTECTED]> menulis:
Dari: Feris Thia <
jangan repot2...
selalu ada solusi jitu...
kae model regex...
tapi gua sendiri gak ngerti regex sama sekali...
so... buat aja method kecil buat apus semi-colon...
assuming that's what you want...
buat gua... better to do it logically right, than syntactically right...
Regards,
Jonathan Handoyo
2
NTO
> TABLE " + tablename + " LINES TERMINATED BY '\\r\\n'");
> } catch (ClassNotFoundException ex) {
> //Logger.getLogger("global").log(Level.SEVERE, null, ex);
> }
> catch (SQLException e) {
> }
> //JOptionPane.showMessageDialog(null,strLi
responnya untuk 6juta
record.
Mungkin ada masukan?
--- On Wed, 11/26/08, Jonathan Handoyo <[EMAIL PROTECTED]> wrote:
From: Jonathan Handoyo <[EMAIL PROTECTED]>
Subject: Re: [JUG-Indonesia] Still how to read data
To: jug-indonesia@yahoogroups.com
Date: Wednesday, November 26, 2
dan di run satu2 koq agak lama responnya untuk
> 6juta record.
> Mungkin ada masukan?
>
>
>
> --- On *Wed, 11/26/08, Jonathan Handoyo <[EMAIL PROTECTED]>*wrote:
>
> From: Jonathan Handoyo <[EMAIL PROTECTED]>
> Subject: Re: [JUG-Indonesia] Still how to read data
Iterate dan concurrency :)
Akan sangat mempercepat
2008/11/27 Jonathan Handoyo <[EMAIL PROTECTED]>
> sama aja bukan...?
> kalo gak bisa pake excel... tinggal copy paste... masukin TOAD... F5...
> tunggu selese...
> sama aja...
> kalo mao pake java... ya mesti bikin iterate gitu...
>
> Regards,
>
mailto:[EMAIL PROTECTED] On Behalf Of
Feris Thia
Sent: Thursday, November 27, 2008 1:53 PM
To: jug-indonesia@yahoogroups.com
Subject: Re: [JUG-Indonesia] Still how to read data
Iterate dan concurrency :)
Akan sangat mempercepat
2008/11/27 Jonathan Handoyo <[EMAIL PROTECTED]>
sama aja bukan
ehalf Of Feris Thia
Sent: Thursday, November 27, 2008
1:53 PM
To: jug-indonesia@ yahoogroups. com
Subject: Re: [JUG-Indonesia] Still
how to read data
Iterate dan concurrency :)
Akan sangat
mempercepat
2008/11/27 Jonathan Handoyo
sama aja bukan...?
kalo gak bisa pake exc
: jug-indonesia@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of
Karsanto S
Sent: Thursday, November 27, 2008 2:41 PM
To: jug-indonesia@yahoogroups.com
Subject: RE: [JUG-Indonesia] Still how to read data
Klo action tersebut terpaksa mesti dilakukan di cilent gmn, om? kmrn pake
sqlloader via
Seperti saran saya pertama,
Pake Kettle (Pentaho Data Integration) yang dasarnya memang adalah Java
library. Rancang pake graphic, dapat file xmlnya... copy paste sebagai
string untuk dieksekusi di code kita.
Mau contoh cara embed ?
Lihat disini :
http://wiki.pentaho.com/display/EAI/Pentaho+Dat
notify the sender immediately and delete it.
NCS Pte. Ltd. - Reg. No. 198101793G
_
From: jug-indonesia@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of
Feris Thia
Sent: Thursday, November 27, 2008 2:54 PM
To: jug-indonesia@yahoogroups.com
Subject: Re: [JUG-Indonesia] Still h
Mungkin bisa oprek-oprek kode nya GoenSheet
sekarang sudah punya kemampuan koneksi ke database.
Salam hangat
connect to javageo.com
2008/11/27 Jonathan Handoyo
sama aja bukan...?
kalo gak bisa pake excel... tinggal copy paste... masukin TOAD... F5...
t
Mungkin bisa oprek-oprek kode nya GoenSheet
sekarang sudah punya kemampuan koneksi ke database.
Salam hangat
connect to javageo.com
2008/11/27 Jonathan Handoyo
sama aja bukan...?
kalo gak bisa pake excel... tinggal copy paste... masukin TOAD... F5...
t
soalnya klo di tokenize dan di run satu2 koq agak lama responnya
untuk 6juta record.
Mungkin ada masukan?
proses tokenizenya mungkin yang lama, terutama kalau menggunakan
String.split(";")
gunakan regex kalau mau, atau iterasi satu per satu karakter dari
baris untuk potong2 stringnya d
Cant live without java yah ?
Ada apa dengan sqlldr nya oracle ? tinggal define control file, trus jalanin
pake opsi rows= dan direct=true, harusnya lebih cepet daripada pake java.
2008/11/27 Hendra Sukma <[EMAIL PROTECTED]>
> Terima kasih atas masukan dari para jugger smua, tapi skarang saya ad
. Ltd. - Reg. No. 198101793G
_
From: jug-indonesia@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of
Lintang Prasojo
Sent: Thursday, November 27, 2008 5:29 PM
To: jug-indonesia@yahoogroups.com
Subject: Re: [JUG-Indonesia] Still how to read data
Cant live without java yah
y the sender immediately and delete it.
>
> NCS Pte. Ltd. - Reg. No. 198101793G
>
>
>
> From: jug-indonesia@yahoogroups.com [mailto:[EMAIL PROTECTED]
> On Behalf Of Lintang Prasojo
> Sent: Thursday, November 27, 2008 5:29 PM
> To: jug-indon
@yahoogroups.com
Subject: Re: [JUG-Indonesia] Still how to read data
mau lebih cepat? salah satunya pake thread.
sebenarnya buat parsing CSV, pake StringTokenizer aja cukup kok.
kalau cuma 6 juta data sih gak begitu lama.
kalo segitu masih dianggap lama, emangnya pinginnya berapa cepet?
pake sqlldr punya
2008/11/28 Adelwin Handoyo <[EMAIL PROTECTED]>:
> Rekor gua sendiri sih 4 juta line itu 2 menit lah...
and how many man-hour previously spent tweaking to achive that 2 minutes? ;-)
--
salam hangat,
Thomas Wiradikusuma
http://wiradikusuma.blogspot.com/2008/11/congratulations-america.html
To: jug-indonesia@yahoogroups.com
Subject: Re: [JUG-Indonesia] Still how to read data
2008/11/28 Adelwin Handoyo <[EMAIL PROTECTED]>:
> Rekor gua sendiri sih 4 juta line itu 2 menit lah...
and how many man-hour previously spent tweaking to achive that 2 minutes? ;-)
--
salam hanga
but not limited to, total or partial reproduction,
> > communication, or dissemination in any form) by persons other than the
> > intended recipient(s) is prohibited. If you have received this e-mail in
> > error, please notify the sender immediately and delete it.
> >
> > NCS Pte.
nded for the sole use of
>> the
>> > recipient(s) named above and may contain information that is
>> confidential
>> > and/or proprietary to the NCS Group. Any use of the information
>> contained
>> > herein (including, but not limited to, total or partial reproduction,
>> > communica
mail ID : [EMAIL PROTECTED]
>>> > Website: http://www.ncs.com.sg
>>> >
>>> > DISCLAIMER *
>>> >
>>> > This e-mail and any attachments thereto are intended for the sole use
>>> of the
>>> > recipient(s) na
ny
JOptionPane.showMessageDialog(null,"Error: " + e.getMessage());
}
--- Pada Jum, 28/11/08, Thomas Wiradikusuma <[EMAIL PROTECTED]> menulis:
Dari: Thomas Wiradikusuma <[EMAIL PROTECTED]>
Topik: Re: [JUG-Indonesia] Still how to read data
Kepada: jug-indonesia@yahoogroups.c
Lho kok makin maksa? Ck ck ck.
On Sat, Nov 29, 2008 at 5:51 PM, Hendra Sukma <[EMAIL PROTECTED]> wrote:
> kok pada kemana sih pembicaraannya, masalah read data saya gimana? TOlong
> donk
> Ini codenya
--
Not by might nor by power, but by His Spirit.
Read my blog: http://joshuajava.wordpress.c
lho?
anda bikin 3 thread dengan pertanyaan yang sama lho...
1st of all...
ini saya sendiri gak jelas pertanyaan nya dimana..
paste code nya... lalu salah nya dimana?
2nd of all...
udah coba tanya google belom?
coba ajah pake keyword "load data from text java"
liat ajah nih
Results *1* - *10* of ab
Mas Hendra kurang menggali di gugel sepertinya :P
LOAD DATA INFILE <-- bukannya ini buat langsung ngambil csv buat
dimasukin ke table, lalu buat apa diiterate?
langsung aja masukin nama filenya, CMIIW
open ur mind to google, dont hesitate to ask google... jangan cuma di
milis aja (seringnya malah
Saya cuman perna pake LOAD DATA INFILE utk panggil sqlloader buat insert
data dari csv ke table ,
baru tau juga klo bisa sebagai Pengganti Insert (sehingga harus di iterate)
:D
2008/11/30 rEEk 'o hEEk <[EMAIL PROTECTED]>
> Mas Hendra kurang menggali di gugel sepertinya :P
> LOAD DATA INFILE
wui anes dilawan...
jangan sampe dibikinin library gila ne ma anes...
tapi betul itu... mbah gugel is ur friend...
gugel always has the answer...
so long as you ask the right question...
btw, lanjutin discussion yang tadi...
gua gak ngerti race condition nya dimana kalo punya master thread...
makin runyam deh.
sepertinya, ini solusi paling yahud.
cobain pake Kettle aja deh.
sejauh ini, aku seringnya pake,
telah menyelesaikan banyak masalah.
yang sebelumnya, mesti bikin program lagi program lagi.
selamat mencoba.
2008/11/30 Jonathan Handoyo <[EMAIL PROTECTED]>:
> wui anes dilawan...
Bukannya ini simple sekali ya,
mysql> load data infile "divisi.txt" into table hs_test.divisi_t
-> fields terminated by ';';
Query OK, 3 rows affected, 2 warnings (0.24 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 2
mysql> select * from divisi_t;
++---+--+---
37 matches
Mail list logo
