標籤

4GL (1) 人才發展 (10) 人物 (3) 太陽能 (4) 心理 (3) 心靈 (10) 文學 (31) 生活常識 (14) 光學 (1) 名句 (10) 即時通訊軟體 (2) 奇狐 (2) 爬蟲 (1) 音樂 (2) 產業 (5) 郭語錄 (3) 無聊 (3) 統計 (4) 新聞 (1) 經濟學 (1) 經營管理 (42) 解析度 (1) 遊戲 (5) 電學 (1) 網管 (10) 廣告 (1) 數學 (1) 機率 (1) 雜趣 (1) 證券 (4) 證券期貨 (1) ABAP (15) AD (1) agentflow (4) AJAX (1) Android (1) AnyChart (1) Apache (14) BASIS (4) BDL (1) C# (1) Church (1) CIE (1) CO (38) Converter (1) cron (1) CSS (23) DMS (1) DVD (1) Eclipse (1) English (1) excel (5) Exchange (4) Failover (1) Fedora (1) FI (57) File Transfer (1) Firefox (3) FM (2) fourjs (1) Genero (1) gladiatus (1) google (1) Google Maps API (2) grep (1) Grub (1) HR (2) html (23) HTS (8) IE (1) IE 8 (1) IIS (1) IMAP (3) Internet Explorer (1) java (4) JavaScript (22) jQuery (6) JSON (1) K3b (1) ldd (1) LED (3) Linux (116) Linux Mint (4) Load Balance (1) Microsoft (2) MIS (2) MM (51) MSSQL (1) MySQL (27) Network (1) NFS (1) Office (1) OpenSSL (1) Oracle (126) Outlook (3) PDF (6) Perl (60) PHP (33) PL/SQL (1) PL/SQL Developer (1) PM (3) Postfix (2) postfwd (1) PostgreSQL (1) PP (50) python (4) QM (1) Red Hat (4) Reporting Service (28) ruby (11) SAP (234) scp (1) SD (16) sed (1) Selenium (3) Selenium-WebDriver (5) shell (5) SQL (4) SQL server (8) sqlplus (1) SQuirreL SQL Client (1) SSH (2) SWOT (3) Symantec (2) T-SQL (7) Tera Term (2) tip (1) tiptop (23) Tomcat (6) Trouble Shooting (1) Tuning (5) Ubuntu (37) ufw (1) utf-8 (1) VIM (11) Virtual Machine (2) VirtualBox (1) vnc (3) Web Service (2) wget (1) Windows (19) Windows (1) WM (6) Xvfb (2) youtube (1) yum (2)

2013年10月30日 星期三

replace regular expression


replaceAll 不是JavaScript function,要用replace

var ary = CSVToArray(line,",");
var txt1  = ary[0][0];  //項目
var spec  = ary[0][1];  //規格
var preis = ary[0][2];  //單價
var qty   = ary[0][3];  //數量
var amt   = ary[0][4];  //價格
var txt2  = ary[0][5];  //備註
var cat   = ary[0][6];  //類型
var trsf  = ary[0][7];  //是否轉檔
var matnr = ary[0][8];  //料號
var bsart = ary[0][9];  //PR Order Type ; PR類別
var ekgrp = ary[0][10]; //採購代號
var matkl = ary[0][11]; //material group

if (preis.indexOf(",") >= 0) {
  preis = preis.replace(/,/g,"");
}
if (qty.indexOf(",") >= 0) {
  qty = qty.replace(/,/g,"");
}
if (amt.indexOf(",") >= 0) {
  amt = amt.replace(/,/g,"");
}
preis = parseFloat(preis);
qty = parseFloat(qty);
amt = parseFloat(amt);

沒有留言:

張貼留言