【免费】自动筛选工具20230718资源-CSDN文库

共3个文件

csv：2个

html：1个

需积分: 0 56 浏览量 2023-07-19 00:55:51 上传评论收藏 3KB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

自动筛选工具.zip （3个子文件）

Log

HN058_VRR_nil_20230618065635_S44-973290310D30309006290_2023061806_CH2.0_TEST_NG.csv 400B

HN058_VRR_nil_20230618065635_S44-973290310D30309006291_2023061806_CH1.0_TEST_NG.csv 400B

自动筛选NG工具.html 4KB

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>自动筛选NG数据</title> </head> <body> <div id="title" style="width: 90%; height: 50px; margin: auto; background: orange; text-align: center; align-self: center; line-height: 50px; font-size: 35px;">自动筛选NG数据工具</div> <div id="banner" style="width: 90%; height: 50px; margin: auto; position: relative;"> <div id="file" style="width: 79%; height: 50px; margin-top: 10px; background: #4472C4; float:left; display:inline; position: relative;"> <input type="file" multiple name="" id="fileSeclect" style="width: 500px; height: 50px; text-align: center; align-self: center; line-height: 50px; font-size: 20px;">  </div> <div id="btn" style="width: 19%; height: 50px; margin-top: 10px; background: #FFC000; text-align: center; line-height: 50px; font-size: 20px; float: right; display: inline; position: relative;"> 开始处理数据 </div> </div> <div id="result" style="width: 90%; height: 1000px; margin-top: 20px; margin-left: auto; margin-right: auto; background: #A5A5A5; text-align: left; align-self: center; line-height: 50px; font-size: 35px"> <textarea id="txt" style="width: 99.7%; height: 100%; background: #A5A5A5;"></textarea> </div> <script type="text/javascript"> let result = 'ID,实测VRR1,实测VRR2,实测VRR3'; //获取读取文件的File对象 function readF(num) { var selectedFile = document.getElementById('fileSeclect').files; if (selectedFile.length == 0) { alert("请选择文件！"); return; } let new_Num = num; if (new_Num < selectedFile.length) { let file = selectedFile[new_Num]; let fileName = selectedFile[new_Num].name; let reader = new FileReader(); reader.readAsText(file); reader.onloadend = function(e) { let str = e.target.result; let strArray = str.split(/[(\r\n)\r\n]+/); compareData(strArray, fileName) new_Num++; readF(new_Num); } }else { document.getElementById('txt').innerHTML = "所有数据已经筛选完毕了！"; saveResulttoCSV(result) } } function compareData(strArr, fileName) { var data1 = strArr[3].split(",")[10].substring(0,4); var data2 = strArr[4].split(",")[10].substring(0,4); var data3 = strArr[5].split(",")[10].substring(0,4); //console.log(fileName + ' -- ' + data1 + ' -- ' + data2 + ' -- ' +data3) if (parseFloat(data1) > 5 || parseFloat(data2) > 5 || parseFloat(data3) > 5) { result += '\n' + fileName.substring(29,54) + ',' + data1 + ',' + data2 + ',' + data3 } } function saveResulttoCSV(result) { var csvString = "data:text/csv;charset=utf-8,\ufeff" + encodeURIComponent(result); let link = document.createElement('a'); link.href = csvString; link.download = "最终结果数据.csv"; document.body.appendChild(link); link.click(); document.body.removeChild(link); } function main() { readF(0); } var view = document.getElementById('btn'); btn.onclick = main; </script> </body> </html>

评论收藏

内容反馈