Ho trasformato tramite un programma un calcolo di excel in una pagina asp ma questi ha usato la codifica americana, cosicchè come divisorio delle migliaia mi usa la virgola (mentre noi usiamo il punto) e come divisorio per i centesimi mi usa il punto (mentre noi usiamo la virgola)...come faccio per invertire questa punteggiatura?
Qui sotto la stringa javascript di riferimento, spero mi possiate aiutare:
var co = new Object;
function recalc_onclick(ctl) {
if (true) {
co.pA7B=eeparseFloatTh(document.formc.pA7B.value); co.pA8B=eeparseFloat(document.formc.pA8B.value);co .pA9B=eeparseFloat(document.formc.pA9B.value);calc (co);document.formc.pA10B.value=eedatefmt(fmtdate8 ,co.pA10B);document.formc.pA12B.value=eedatefmt(fm tdate8,co.pA12B);document.formc.pA17B.value=eedate fmt(fmtdate8,co.pA17B);document.formc.pA18B.value= eedisplayFloatNDTh(co.pA18B,2);document.formc.pA20 B.value=eedatefmt(fmtdate8,co.pA20B);document.form c.pA22B.value=eedatefmt(fmtdate8,co.pA22B);documen t.formc.pA24B.value=eedatefmt(fmtdate8,co.pA24B);
};};
var eeisus=1;var eetrue="TRUE";var eefalse="FALSE";var eedec=".";var eeth=",";var eedecreg=new RegExp("\\.","g");var eethreg=new RegExp(",","g");var eecurrencyreg=new RegExp("[$]","g");var eepercentreg=new RegExp("%","g"); var fmtdaynamesshort=new Array("Sun","Mon","Tue","Wed","Thu","Fri","Sat"); var fmtdaynameslong=new Array("Sunday","Monday","Tuesday","Wednesday","Thu rsday","Friday","Saturday"); var fmtmonthnamesshort=new Array("Jan","Feb","Mar","Apr","May","Jun","Jul","A ug","Sep","Oct","Nov","Dec"); var fmtmonthnameslong=new Array("January","February","March","April","May"," June","July","August","September","October","Novem ber","December"); var fmtstrings=new Array(","," ","€"); var fmtdate8=new Array(34,33,25,2);
function calc(data){var cA7B=data.pA7B;var cA8B=data.pA8B;var cA9B=data.pA9B;var cA17B=(((15)*(1)));var cA10B=(((30000)/(cA9B)));var cA12B=(((((((1.2)*(cA8B)))*(cA7B)))+(cA10B)));var cA18B=(cA8B);var cA20B=(((((3)*(cA18B)))*(cA17B)));var cA22B=(((cA12B)-(cA20B)));var cA24B=(((cA9B)*(cA22B)));data.pA10B=cA10B;data.pA1 2B=cA12B;data.pA17B=cA17B;data.pA18B=cA18B;data.pA 20B=cA20B;data.pA22B=cA22B;data.pA24B=cA24B;};
function myIsNaN(x){return(isNaN(x)||(typeof x=='number'&&!isFinite(x)));};function mod(n,d){return n-d*Math.floor(n/d);};function round(n,nd){if(isFinite(n)&&isFinite(nd)){var sign_n=(n<0)?-1:1;var abs_n=Math.abs(n);var factor=Math.pow(10,nd);return sign_n*Math.round(abs_n*factor)/factor;}else{return NaN;}};function eeparseFloat(str){str=String(str).replace(eedecreg ,".");var res=parseFloat(str);if(isNaN(res)){return 0;}else{return res;}};var near0RegExp=new RegExp("[.](.*0000000|.*9999999)");function eedisplayFloat(x){if(myIsNaN(x)){return Number.NaN;}else{var str=String(x);if(near0RegExp.test(str)){x=round(x, 8);str=String(x);}return str.replace(/\./g,eedec);}};function eedisplayScientific(x,nd){if(myIsNaN(x)){return Number.NaN;}else{var str=String(x.toExponential(nd));return str.replace(/\./g,eedec);}};function eedisplayFloatND(x,nd){if(myIsNaN(x)){return Number.NaN;}else{var res=round(x,nd);if(nd>0){var str=String(res);if(str.indexOf('e')!=-1)return str;if(str.indexOf('E')!=-1)return str;var parts=str.split('.');if(parts.length<2){var decimals=('00000000000000').substring(0,nd);return (parts[0]).toString()+eedec+decimals;}else{var decimals=((parts[1]).toString()+'00000000000000').substring(0,nd);ret urn(parts[0]).toString()+eedec+decimals;}}else{return res;}}};function eedisplayPercent(x){if(myIsNaN(x)){return Number.NaN;}else{return eedisplayFloat(x*100)+'%';}};function eedisplayPercentND(x,nd){if(myIsNaN(x)){return Number.NaN;}else{return eedisplayFloatND(x*100,nd)+'%';}}
function eeparseFloatTh(str){str=String(str).replace(eethre g,"");str=String(str).replace(eedecreg,".");var res=parseFloat(str);if(isNaN(res)){return 0;}else{return res;}};function eedisplayFloatNDTh(x,nd){if(myIsNaN(x)){return Number.NaN;}else{var res=round(x,nd);if(nd>0){var str=String(res);if(str.indexOf('e')!=-1)return str;if(str.indexOf('E')!=-1)return str;var parts=str.split('.');var res2=eeinsertThousand(parts[0].toString());if(parts.length<2){var decimals=('00000000000000').substring(0,nd);return (res2+eedec+decimals);}else{var decimals=((parts[1]).toString()+'00000000000000').substring(0,nd);ret urn(res2+eedec+decimals);}}else{return(eeinsertTho usand(res.toString()));}}};function eedisplayPercentNDTh(x,nd){if(myIsNaN(x)){return Number.NaN;}else{return eedisplayFloatNDTh(x*100,nd)+'%';}}function eeinsertThousand(whole){if(whole==""||whole.indexO f("e")>=0){return whole;}else{var minus_sign="";if(whole.charAt(0)=="-"){minus_sign="-";whole=whole.substring(1);};var res="";var str_length=whole.length-1;for(var ii=0;ii<=str_length;ii++){if(ii>0&&ii%3==0){res=ee th+res;};res=whole.charAt(str_length-ii)+res;};return minus_sign+res;}};function eedatefmt(fmt,x){if(!isFinite(x))return Number.NaN;var padding=0;var tmp=0;var res="";var len=fmt.length;for(var ii=0;ii<len;ii++){if(fmt[ii]>31){res+=fmtstrings[fmt[ii]-32];}else{switch(fmt[ii]){case 2:res+=eemonth(x);break;case 3:tmp=eemonth(x);if(tmp<10){res+="0";};res+=tmp;br eak;case 4:res+=fmtmonthnamesshort[eemonth(x)-1];break;case 5:res+=fmtmonthnameslong[eemonth(x)-1];break;case 6:res+=eeday(x);break;case 7:tmp=eeday(x);if(tmp<10){res+="0";};res+=tmp;brea k;case 8:res+=fmtdaynamesshort[weekday(x,1)-1];break;case 9:res+=fmtdaynameslong[weekday(x,1)-1];break;case 10:tmp=year(x)%100;if(tmp<10){res+="0";};res+=tmp; break;case 11:res+=year(x);break;case 12:res+=hour(x);break;case 13:tmp=hour(x);if(tmp<10){res+="0";};res+=tmp;brea k;case 14:tmp=hour(x)%12;if(tmp==0){res+="12";}else{res+= tmp%12;};break;case 15:tmp=hour(x)%12;if(tmp==0){res+="12";}else{if(tm p<10){res+="0";};res+=tmp;};break;case 16:res+=minute(x);break;case 17:tmp=minute(x);if(tmp<10){res+="0";};res+=tmp;br eak;case 18:res+=second(x);break;case 19:tmp=second(x);if(tmp<10){res+="0";};res+=tmp;br eak;case 21:case 22:if(hour(x)<12){res+="AM";}else{res+="PM";};brea k;case 23:res+=eedisplayFloat(x);break;case 24:tmp=fmt[++ii];res+=eedisplayFloatND(x,tmp);break;case 25:tmp=fmt[++ii];res+=eedisplayFloatNDTh(x,tmp);break;case 26:res+=eedisplayPercent(x);break;case 27:tmp=fmt[++ii];res+=eedisplayPercentND(x,tmp);break;case 28:tmp=fmt[++ii];res+=eedisplayPercentNDTh(x,tmp);break;case 29:tmp=fmt[++ii];res+=eedisplayScientific(x,tmp);break;case 30adding=fmt[++ii];tmp=hour(x)+Math.floor(x)*24;tmp=tmp.toString();i f(tmp.length<padding){res+=('00000000000000').subs tring(0,padding-tmp.length);}res+=tmp;break;};};};return res;};
function leap_gregorian(year){return((year%4)==0)&&(!(((yea r%100)==0)&&((year%400)!=0)));}var GREGORIAN_EPOCH=1721425;function gregorian_to_jd(year,month,day){return(GREGORIAN_E POCH-0)+(365*(year-1))+Math.floor((year-1)/4)+(-Math.floor((year-1)/100))+Math.floor((year-1)/400)+Math.floor((((367*month)-362)/12)+((month<=2)?0leap_gregorian(year)?-1:-2))+day);}function jd_to_gregorian(jd){var wjd,depoch,quadricent,dqc,cent,dcent,quad,dquad,yi ndex,year,yearday,leapadj;wjd=Math.floor(jd);depoc h=wjd-GREGORIAN_EPOCH-1;quadricent=Math.floor(depoch/146097);dqc=mod(depoch,146097);cent=Math.floor(dqc/36524);dcent=mod(dqc,36524);quad=Math.floor(dcent/1461);dquad=mod(dcent,1461);yindex=Math.floor(dqua d/365);year=(quadricent*400)+(cent*100)+(quad*4)+yin dex;if(!((cent==4)||(yindex==4))){year++;}yearday= wjd-gregorian_to_jd(year,1,1);leapadj=((wjd<gregorian_ to_jd(year,3,1))?0
function eemonth(serial_number){if(!isFinite(serial_number) )return Number.NaN;if(serial_number<1){return 1;}if(serial_number>60)serial_number--;var res=jd_to_gregorian(serial_number+2415020);return res[1];};function second(serial_number){if(!isFinite(serial_number)) return Number.NaN;var res=Math.floor((serial_number-Math.floor(serial_number))*86400+0.5);return res%60;};function weekday(serial_number,return_type){if(!isFinite(re turn_type)||!isFinite(serial_number))return Number.NaN;if(return_type<1||return_type>3)return Number.NaN;var res=Math.floor(serial_number+6)%7;switch(Math.floo r(return_type)){case 1:return res+1;case 2:return(res+6)%7+1;case 3:return(res+6)%7;};return "hej";};function year(serial_number){if(!isFinite(serial_number))re turn Number.NaN;if(serial_number<1){return 1900;}if(serial_number>60)serial_number--;var res=jd_to_gregorian(serial_number+2415020);return res[0];};
</script>
grazie a tutti!
ciao!
Rispondi quotando
