Forum › Internet Service & Networking › unix scripting: minta tolong

adekmanes Publish time 28-5-2009 02:13 PM

unix scripting: minta tolong

Camne nak baca dr flat file/xls
pastu extract value , masuk ke output file

cth:
test.xls
column1column2column3
1             2            3
11         22            33
-------------------------------

script akan loop and readcolumn2 and append ke string, output ke myfile.txt, spt dibwh:
myfile.txt
the result is 2 value;
the result is 22 value;

diakhirnya test.xls tu kene delete.

So, ade sesiapa leh tolong. mekasih byk.

lipans Publish time 28-5-2009 02:31 PM

tak bape paham sangat... camni kot boleh ek...

for i in `cat test.xls | grep -v column`
do
echo result is $i
done

lipans Publish time 28-5-2009 02:32 PM

add line... rm test.xls kalau nakk delete ....

cepheid Publish time 29-5-2009 03:13 AM

unix boleh baca excel file ke? selalunya guna text file je

farid_ib Publish time 30-5-2009 02:59 AM

mengapa tidak menggunakan java?<br />
<br />
bukankah adekmanis tere java?

View full version: unix scripting: minta tolong