blocks|key|4018026|text|这是一个3x3的表格，它检查每个输入是否都有字母e。如果每个单元格都有字母e，它会提示单词"Common+Letter!"，您可以将其替换为您想要的任何内容。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4018027|​|4018028|var+checked+=+[];

function+check(elem)+{
++++var+elemArr+=+elem.value.split("");
++++if+(elemArr.includes("e")+{
++++++++if+(!(checked.includes(elem.id)))+{
++++++++++++checked.push(elem.id);
++++++++}
++++}
++++if+(checked.length+>=+9)+{
++++++++//Do+your+thing+here
++++++++alert("Common+Letter!");
++++}
}|code-block|syntax|javascript|4018029|<table>
++++<tr>
++++++++<td>
++++++++++++<input+id="input-1-1"+type="text"+oninput="check(this")/>
++++++++</td>
++++++++<td>
++++++++++++<input+id="input-1-2"+type="text"+oninput="check(this")+/>
++++++++</td>
++++++++<td>
++++++++++++<input+id="input-1-3"+type="text"+oninput="check(this")+/>
++++++++</td>
++++</tr>
++++<tr>
++++++++<td>
++++++++++++<input+id="input-2-1"+type="text"+oninput="check(this")+/>
++++++++</td>
++++++++<td>
++++++++++++<input+id="input-2-2"+type="text"+oninput="check(this")+/>
++++++++</td>
++++++++<td>
++++++++++++<input+id="input-2-3"+type="text"+oninput="check(this")+/>
++++++++</td>
++++</tr>
++++<tr>
++++++++<td>
++++++++++++<input+id="input-3-1"+type="text"+oninput="check(this")+/>
++++++++</td>
++++++++<td>
++++++++++++<input+id="input-3-2"+type="text"+oninput="check(this")+/>
++++++++</td>
++++++++<td>
++++++++++++<input+id="input-3-3"+type="text"+oninput="check(this")+/>
++++++++</td>
++++</tr>
</table>|4018030|4018031|entityMap^0|O|1|11|1|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|X|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|O|3|G|5|6|7|Z|8|@]|D|@]|E|$]]|$1|P|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|Q|$]]

<p>Here's a 3 by 3 table which checks if each input has the letter <code>e</code>. If every cell has the letter <code>e</code>, it alerts the words "Common Letter!", which you can replace with whatever you want.</p>

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-js lang-js prettyprint-override"><code>var checked = [];

function check(elem) {
    var elemArr = elem.value.split("");
    if (elemArr.includes("e") {
        if (!(checked.includes(elem.id))) {
            checked.push(elem.id);
        }
    }
    if (checked.length &gt;= 9) {
        //Do your thing here
        alert("Common Letter!");
    }
}</code></pre>
<pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;table&gt;
    &lt;tr&gt;
        &lt;td&gt;
            &lt;input id="input-1-1" type="text" oninput="check(this")/&gt;
        &lt;/td&gt;
        &lt;td&gt;
            &lt;input id="input-1-2" type="text" oninput="check(this") /&gt;
        &lt;/td&gt;
        &lt;td&gt;
            &lt;input id="input-1-3" type="text" oninput="check(this") /&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt;
            &lt;input id="input-2-1" type="text" oninput="check(this") /&gt;
        &lt;/td&gt;
        &lt;td&gt;
            &lt;input id="input-2-2" type="text" oninput="check(this") /&gt;
        &lt;/td&gt;
        &lt;td&gt;
            &lt;input id="input-2-3" type="text" oninput="check(this") /&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt;
            &lt;input id="input-3-1" type="text" oninput="check(this") /&gt;
        &lt;/td&gt;
        &lt;td&gt;
            &lt;input id="input-3-2" type="text" oninput="check(this") /&gt;
        &lt;/td&gt;
        &lt;td&gt;
            &lt;input id="input-3-3" type="text" oninput="check(this") /&gt;
        &lt;/td&gt;
    &lt;/tr&gt;
&lt;/table&gt;</code></pre>
</div>
</div>
</p>


blocks|key|4020172|text|你将不会有一个id，因为信息不会从粘贴中传递过来。不过，我们可以使用从tinyMCE获得的表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4020173|您的需求不是很清楚，但以下内容应该会让您朝着正确的方向前进|4020174|​|4020175|//From+tinymce.activeEditor.getContent()
var+tableString+='<table+border="0"+width="156"+cellspacing="0"+cellpadding="0"><colgroup><col+width="72"+/>+<col+width="49"+/>+<col+width="35"+/></colgroup><tbody><tr><td+align="right"+width="72"+height="20">15</td><td+align="right"+width="49">1.35</td><td+align="right"+width="35">3.58</td></tr><tr><td+height="20">&nbsp;&nbsp;&nbsp;+12.0s5o9</td><td+align="right">123.56</td><td+align="right">5.15</td></tr></tbody></table>';

//we+could+add+the+table+straight+to+the+DOM,+but+as
//we+aren't+sure+as+to+what+you+wnat+to+do+lets+create+a+
//"virtual"+DOM+node
var+dv+=+document.createElement('div');

//Add+Table+string+to+out+holder+node
dv.innerHTML+=+tableString;

//Get+the+actual+table
var+tableDOM+=+dv.firstChild;+

//get+table+cells
var+tds+=+tableDOM.querySelectorAll("td");
var+total+=+0.0;

//Loop+through+the+cells.
for(var+i+=+0;+i+<+tds.length;+i%2B%2B)
{
++var+val+=+tds[i].innerText.trim();
++//numeric+check
++if(isNaN(val)+%7C%7C+isNaN(parseFloat(val)))++{
++++//Highlite+non+numeric+cell+-you+could+add+a+class+here+instead
++++tds[i].style.color+=+"#F00";
++}else{
++++//Add+numeric+cells+to+total
++++total+%2B=+parseFloat(val);
++}
}
//Log+the+toal
console.log(total);

//Add+the+Table+to+the+visible+DOM
document.getElementById("result").appendChild(tableDOM);

//Or+if+you+want+to+replace+the+contents+of+your+editor:
//tinymce.activeEditor.setContent(tableDOM.outerHTML);|code-block|syntax|javascript|4020176|<div+id="result"></div>|4020177|4020178|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|S|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|H|7|T|8|@]|9|@]|A|$I|J]]|$1|M|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|O|$]]

<p>You won't have an id as such as that info does not come across from the paste. We can work with the table you get from tinyMCE though.</p>

<p>Your requirements are not exactly clear, but the following should get you moving in the right direction</p>

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-js lang-js prettyprint-override"><code>//From tinymce.activeEditor.getContent()
var tableString ='&lt;table border="0" width="156" cellspacing="0" cellpadding="0"&gt;&lt;colgroup&gt;&lt;col width="72" /&gt; &lt;col width="49" /&gt; &lt;col width="35" /&gt;&lt;/colgroup&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td align="right" width="72" height="20"&gt;15&lt;/td&gt;&lt;td align="right" width="49"&gt;1.35&lt;/td&gt;&lt;td align="right" width="35"&gt;3.58&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td height="20"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; 12.0s5o9&lt;/td&gt;&lt;td align="right"&gt;123.56&lt;/td&gt;&lt;td align="right"&gt;5.15&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;';

//we could add the table straight to the DOM, but as
//we aren't sure as to what you wnat to do lets create a 
//"virtual" DOM node
var dv = document.createElement('div');

//Add Table string to out holder node
dv.innerHTML = tableString;

//Get the actual table
var tableDOM = dv.firstChild; 

//get table cells
var tds = tableDOM.querySelectorAll("td");
var total = 0.0;

//Loop through the cells.
for(var i = 0; i &lt; tds.length; i++)
{
  var val = tds[i].innerText.trim();
  //numeric check
  if(isNaN(val) || isNaN(parseFloat(val)))  {
    //Highlite non numeric cell -you could add a class here instead
    tds[i].style.color = "#F00";
  }else{
    //Add numeric cells to total
    total += parseFloat(val);
  }
}
//Log the toal
console.log(total);

//Add the Table to the visible DOM
document.getElementById("result").appendChild(tableDOM);

//Or if you want to replace the contents of your editor:
//tinymce.activeEditor.setContent(tableDOM.outerHTML);</code></pre>
<pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;div id="result"&gt;&lt;/div&gt;</code></pre>
</div>
</div>
</p>


<p>I am building a website that can copy-paste table from MS.Excel or MS.Word into a text area.</p>

<pre><code>15.00 1.35 3.58  
12.0s5o9 123.56 5.15
</code></pre>

<p>I want to get value from each cell with Id. Ex: Id11 = 15.00, Id12 = 1.35, Id21 = 12.0s5o9 ...<br>
Then check the number if it contain letter, then highlight that cell. Ex: Id21 = 12.0s5o9 that should be highlighted.  </p>

<p>After trying some codes by myself, I changed to try using 'tinymce' texteditor as below.<br>
HTML code I wrote:</p>

<pre><code>&lt;form id="converted_form"&gt;
&lt;textarea id="content" name="content"&gt;&lt;/textarea&gt;
&lt;input type="button" id="btn" value="Submit" /&gt;
&lt;/form&gt;
&lt;script language="javascript" src="check.js"&gt;&lt;/script&gt;
</code></pre>

<p>In Javascript I wrote:</p>

<pre><code>var btn = document.getElementById("btn"); 
btn.addEventListener("click",function(){ var content = 
tinymce.activeEditor.getContent()
</code></pre>

<p>What I got is:</p>

<pre><code>&lt;table border="0" width="156" cellspacing="0" cellpadding="0"&gt;&lt;colgroup&gt;&lt;col width="72" /&gt; &lt;col width="49" /&gt; &lt;col width="35" /&gt;&lt;/colgroup&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td align="right" width="72" height="20"&gt;15&lt;/td&gt;
&lt;td align="right" width="49"&gt;1.35&lt;/td&gt;
&lt;td align="right" width="35"&gt;3.58&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td height="20"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; 12.0s5o9&lt;/td&gt;
&lt;td align="right"&gt;123.56&lt;/td&gt;
&lt;td align="right"&gt;5.15&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;
</code></pre>

<p>This does not contain Id of each cell for me to check and highlight the cell that contain letter.<br>
Can anyone share idea to get cell value and Id; or other way beside tinymce?</p>


HTML, Javascript: check and get data from an input copy-pasted table

我正在建立一个网站，可以复制粘贴表格从MS.Excel或MS.Word到一个文本区。15.00 1.35 3.58  12.0s5o9 123.56 5.15我想从每个具有Id的单元格中获取值。例如: Id11 = 15.00，Id12 = 1.35，Id21 =12.0s5o9...然后检查数字是否包含字母，然后突出...

问HTML、Javascript:检查并从输入的复制粘贴的表格中获取数据
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问HTML、Javascript:检查并从输入的复制粘贴的表格中获取数据EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问HTML、Javascript:检查并从输入的复制粘贴的表格中获取数据
EN