| | |
|---|
| | | let min = null; |
|---|
| | | if (val && val.length > 0) { |
|---|
| | | val = val.filter((item) => item != null && item !== ""); |
|---|
| | | // console.log(val) |
|---|
| | | if (val.length > 0) { |
|---|
| | | min = Math.min(...val); |
|---|
| | | } |
|---|
| | |
|---|
| | | function getABCList(f) { |
|---|
| | | try { |
|---|
| | | let regex = /[=\+\-\*\%\(\)\/\^\s]/g; |
|---|
| | | let fouList = ["SUM", "MAX", "MIN", "AVERAGE", "ABS"]; |
|---|
| | | let fouList = ["SUM", "MAX", "MIN", "AVERAGE", "ABS","SQRT"]; |
|---|
| | | f = f |
|---|
| | | .replace(regex, ",") |
|---|
| | | .replace(new RegExp('"&', "g"), "") |
|---|
| | |
|---|
| | | fouList.forEach((item) => { |
|---|
| | | f = f.replace(new RegExp(item, "g"), ""); |
|---|
| | | }); |
|---|
| | | // console.log('f',f) |
|---|
| | | let arr = f.split(",").filter((item) => { |
|---|
| | | return ( |
|---|
| | | item && /[a-zA-Z]/.test(item) && item != "undefined" && item != "null" |
|---|
