user26136009提出的问题 -coding

user26136009

Asked: 2025-03-31 20:05:18 +0800 CST

Caixas de seleção de contagem de Javascript não funcionam

o seguinte código Javascript funciona na contagem de quantas caixas de seleção estão marcadas e destaca a linha em laranja:

function countCheckboxes() {
  var form = document.getElementById('frmAds');
  var count = 0;
  for (var n = 0; n < form.length; n++) {
    if (form[n].name === `chk[${n+1}]` && form[n].checked) {
      count++;
    }
  }

  document.getElementById('checkCount').innerHTML = " <b>" + count + "</b> rows are checked";
}

function toggleColour(obj, col) {
  col = col || 'transparent'
  var row = findParentRow(obj);
  if (!row.col) row.col = row.style.backgroundColor;
  row.style.backgroundColor = obj.checked ? row.col : col;

  countCheckboxes(); // Update the count when checkbox is clicked
}

function findParentRow(obj) {
  var tmp = obj.parentNode;
  if (tmp.nodeName.toLowerCase() != "tr") {
    tmp = findParentRow(tmp);
  }
  return tmp;
}

window.onload = countCheckboxes;

<form action="import.php" enctype="multipart/form-data" method="post" id="frmAds">
  <table>
    <tr>
      <td>
        <input type="checkbox" value="1" name="chk[1]" checked="checked" onClick="toggleColour(this,'#FEAB2F');" />
      </td>
      <td>test 1</td>
    </tr>
    <tr>
      <td>
        <input type="checkbox" value="1" name="chk[2]" checked="checked" onClick="toggleColour(this,'#FEAB2F');" />
      </td>
      <td>test 2</td>
    </tr>
    <tr style="background-color:white;">
      <td class="bigtext"><input type="checkbox" value="1" name="chk[3]" checked="checked" onClick="toggleColour(this,'#FEAB2F');" /></td>
      <td class="bigtext">1</td>
      <td class=" bigtext"><input type="hidden" value="03/28/2025" name="date[1]" />03/28/2025</td>
      <td class="bigtext"><input type="text" size="56" value="Chase - IN *CARTERS TOWING AND RE" name="desc[1]" maxlength="190" style="border: none; padding: 4px; font-size: 12px;" /></td>
      <td class="bigtext"><select name="cat[1]">
          <option value="1" selected="selected">(**NO MATCH**)</option>
          <option value="829">(Work) Hotel Stay</option>
          <option value="818">(Work) Uber and Taxi</option>
          <option value="45">Accountant</option>
          <option value="850">Addon Asset</option>
          <option value="2">Bank Dividends</option>
          <option value="3">Bank Interest</option>
          <option value="16">Business Local Taxes</option>
          <option value="821">Cashback Reward</option>
          <option value="864">Commissions &amp; Fees</option>
          <option value="70">DELETE THIS?</option>
          <option value="55">Dental</option>
          <option value="872">Ebay Items</option>
          <option value="50">Estimated Taxes</option>
          <option value="18">Health Insurance</option>
          <option value="53">Medical Services</option>
          <option value="7">Mobile Internet</option>
          <option value="861">Office Rent</option>
          <option value="78">OTR MEALS - Dining</option>
          <option value="81">OTR Meals - Fast Food</option>
          <option value="855">Personal - Air Travel</option>
          <option value="67">Personal - ATM</option>
          <option value="866">Personal - Bank Fees</option>
          <option value="843">Personal - Bug Prevention</option>
          <option value="75">Personal - Car Insurance</option>
          <option value="845">Personal - Car Loan</option>
          <option value="69">Personal - Car Maintenance</option>
          <option value="847">Personal - Car Upgrades</option>
          <option value="72">Personal - Car Wash</option>
          <option value="66">Personal - Clothing</option>
          <option value="61">Personal - Dining</option>
          <option value="89">Personal - Dry Cleaners</option>
          <option value="92">Personal - Electric Bill</option>
          <option value="84">Personal - Entertainment</option>
          <option value="62">Personal - Fast Food</option>
          <option value="867">Personal - Fundrise Investment</option>
          <option value="60">Personal - Gasoline</option>
          <option value="63">Personal - Groceries</option>
          <option value="64">Personal - Haircuts</option>
          <option value="814">Personal - Home Insurance</option>
          <option value="68">Personal - Home Items</option>
          <option value="863">Personal - Home Maintenance</option>
          <option value="94">Personal - Home Security</option>
          <option value="811">Personal - Interest Payments</option>
          <option value="83">Personal - Landscaping</option>
          <option value="71">Personal - Licenses</option>
          <option value="95">Personal - Local Internet</option>
          <option value="97">Personal - Mailbox</option>
          <option value="844">Personal - Miscellaneous</option>
          <option value="76">Personal - Mortgage</option>
          <option value="876">Personal - Mutual Funds</option>
          <option value="862">Personal - Natural Gas</option>
          <option value="857">Personal - Phone Apps</option>
          <option value="819">Personal - Rental Car</option>
          <option value="65">Personal - Shopping</option>
          <option value="873">Personal - Transfers</option>
          <option value="46">Personal - Trash Disposal</option>
          <option value="851">Personal - Truck Upgrades</option>
          <option value="827">Personal - Uber and Taxi</option>
          <option value="885">Personal - Umbrella</option>
          <option value="93">Personal - Water Bill</option>
          <option value="98">Personal - Web Hosting</option>
          <option value="90">Personal - Wine</option>
          <option value="21">PO Box</option>
          <option value="54">Prescriptions</option>
          <option value="813">Property Taxes</option>
          <option value="822">Refunds</option>
          <option value="874">SBA Loan</option>
          <option value="840">State Permits</option>
          <option value="878">Trailer Repair</option>
          <option value="839">Truck 2290</option>
          <option value="849">Truck DACH</option>
          <option value="824">Truck Fuel</option>
          <option value="836">Truck IFTA</option>
          <option value="830">Truck Insurance</option>
          <option value="875">Truck Lumpers</option>
          <option value="832">Truck Maintenance</option>
          <option value="858">Truck Parking</option>
          <option value="834">Truck Payment</option>
          <option value="831">Truck Repairs</option>
          <option value="838">Truck SCAC</option>
          <option value="826">Truck Software</option>
          <option value="58">Truck Supplies</option>
          <option value="833">Truck Tolls</option>
          <option value="837">Truck UCR</option>
          <option value="825">Truck Wash</option>
          <option value="86">W2 Payroll (After Tax)</option>
        </select></td>
      <td class="bigtext" nowrap><input type="hidden" value="-350.00" name="amount[1]" />
        <font color="red">$-350.00</font>
      </td>

    </tr>
    <tr>
      <td>
        <p id="checkCount"> </p>
      </td>
    </tr>
  </table>
</form>

O problema estranho é quando adiciono esse código ao meu site principal, onde todas as linhas são como a de baixo, ele não funciona de jeito nenhum. Tentei remover tudo manualmente, um por um, para ver qual é o problema, e parece funcionar quando excluo os campos select e input, exceto o campo chk checkbox. Aqui está a versão que não funciona:

function countCheckboxes() {
  var form = document.getElementById('frmAds');
  var count = 0;
  for (var n = 0; n < form.length; n++) {
    if (form[n].name === `chk[${n+1}]` && form[n].checked) {
      count++;
    }
  }

  document.getElementById('checkCount').innerHTML = " <b>" + count + "</b> rows are checked";
}

function toggleColour(obj, col) {
  col = col || 'transparent'
  var row = findParentRow(obj);
  if (!row.col) row.col = row.style.backgroundColor;
  row.style.backgroundColor = obj.checked ? row.col : col;

  countCheckboxes(); // Update the count when checkbox is clicked
}

function findParentRow(obj) {
  var tmp = obj.parentNode;
  if (tmp.nodeName.toLowerCase() != "tr") {
    tmp = findParentRow(tmp);
  }
  return tmp;
}

window.onload = countCheckboxes;

<form action="import.php" enctype="multipart/form-data" method="post" id="frmAds">
  <table>
    <tr style="background-color:white;">
      <td class="bigtext"><input type="checkbox" value="1" name="chk[1]" checked="checked" onClick="toggleColour(this,'#FEAB2F');" /></td>
      <td class="bigtext">1</td>
      <td class=" bigtext"><input type="hidden" value="03/28/2025" name="date[1]" />03/28/2025</td>
      <td class="bigtext"><input type="text" size="56" value="CARTERS" name="desc[1]" maxlength="190" style="border: none; padding: 4px; font-size: 12px;" /></td>
      <td class="bigtext"><select name="cat[1]">
          <option value="1" selected="selected">(**NO MATCH**)</option>
          <option value="829">(Work) Hotel Stay</option>
          <option value="818">(Work) Uber and Taxi</option>
          <option value="45">Accountant</option>
          <option value="850">Addon Asset</option>
          <option value="2">Bank Dividends</option>
          <option value="3">Bank Interest</option>
          <option value="16">Business Local Taxes</option>
          <option value="821">Cashback Reward</option>
          <option value="864">Commissions &amp; Fees</option>
          <option value="70">DELETE THIS?</option>
          <option value="55">Dental</option>
          <option value="872">Ebay Items</option>
          <option value="50">Estimated Taxes</option>
          <option value="18">Health Insurance</option>
          <option value="53">Medical Services</option>
          <option value="7">Mobile Internet</option>
          <option value="861">Office Rent</option>
          <option value="78">OTR MEALS - Dining</option>
          <option value="81">OTR Meals - Fast Food</option>
          <option value="855">Personal - Air Travel</option>
          <option value="67">Personal - ATM</option>
          <option value="866">Personal - Bank Fees</option>
          <option value="843">Personal - Bug Prevention</option>
          <option value="75">Personal - Car Insurance</option>
          <option value="845">Personal - Car Loan</option>
          <option value="69">Personal - Car Maintenance</option>
          <option value="847">Personal - Car Upgrades</option>
          <option value="72">Personal - Car Wash</option>
          <option value="66">Personal - Clothing</option>
          <option value="61">Personal - Dining</option>
          <option value="89">Personal - Dry Cleaners</option>
          <option value="92">Personal - Electric Bill</option>
          <option value="84">Personal - Entertainment</option>
          <option value="62">Personal - Fast Food</option>
          <option value="867">Personal - Fundrise Investment</option>
          <option value="60">Personal - Gasoline</option>
          <option value="63">Personal - Groceries</option>
          <option value="64">Personal - Haircuts</option>
          <option value="814">Personal - Home Insurance</option>
          <option value="68">Personal - Home Items</option>
          <option value="863">Personal - Home Maintenance</option>
          <option value="94">Personal - Home Security</option>
          <option value="811">Personal - Interest Payments</option>
          <option value="83">Personal - Landscaping</option>
          <option value="71">Personal - Licenses</option>
          <option value="95">Personal - Local Internet</option>
          <option value="97">Personal - Mailbox</option>
          <option value="844">Personal - Miscellaneous</option>
          <option value="76">Personal - Mortgage</option>
          <option value="876">Personal - Mutual Funds</option>
          <option value="862">Personal - Natural Gas</option>
          <option value="857">Personal - Phone Apps</option>
          <option value="819">Personal - Rental Car</option>
          <option value="65">Personal - Shopping</option>
          <option value="873">Personal - Transfers</option>
          <option value="46">Personal - Trash Disposal</option>
          <option value="851">Personal - Truck Upgrades</option>
          <option value="827">Personal - Uber and Taxi</option>
          <option value="885">Personal - Umbrella</option>
          <option value="93">Personal - Water Bill</option>
          <option value="98">Personal - Web Hosting</option>
          <option value="90">Personal - Wine</option>
          <option value="21">PO Box</option>
          <option value="54">Prescriptions</option>
          <option value="813">Property Taxes</option>
          <option value="822">Refunds</option>
          <option value="874">SBA Loan</option>
          <option value="840">State Permits</option>
          <option value="878">Trailer Repair</option>
          <option value="839">Truck 2290</option>
          <option value="849">Truck DACH</option>
          <option value="824">Truck Fuel</option>
          <option value="836">Truck IFTA</option>
          <option value="830">Truck Insurance</option>
          <option value="875">Truck Lumpers</option>
          <option value="832">Truck Maintenance</option>
          <option value="858">Truck Parking</option>
          <option value="834">Truck Payment</option>
          <option value="831">Truck Repairs</option>
          <option value="838">Truck SCAC</option>
          <option value="826">Truck Software</option>
          <option value="58">Truck Supplies</option>
          <option value="833">Truck Tolls</option>
          <option value="837">Truck UCR</option>
          <option value="825">Truck Wash</option>
          <option value="86">W2 Payroll (After Tax)</option>
        </select></td>
      <td class="bigtext" nowrap><input type="hidden" value="-350.00" name="amount[1]" />
        <font color="red">$-350.00</font>
      </td>

    </tr>
    <tr style="background-color:white;">
      <td class="bigtext"><input type="checkbox" value="1" name="chk[2]" checked="checked" onClick="toggleColour(this,'#FEAB2F');" /></td>
      <td class="bigtext">2</td>
      <td class=" bigtext"><input type="hidden" value="03/28/2025" name="date[2]" />03/28/2025</td>
      <td class="bigtext"><input type="text" size="56" value="EXXON" name="desc[2]" maxlength="190" style="border: none; padding: 4px; font-size: 12px;" /></td>
      <td class="bigtext"><select name="cat[2]">
          <option value="81" selected="selected">OTR Meals - Fast Food</option>
          <option value="829">(Work) Hotel Stay</option>
          <option value="818">(Work) Uber and Taxi</option>
          <option value="45">Accountant</option>
          <option value="850">Addon Asset</option>
          <option value="2">Bank Dividends</option>
          <option value="3">Bank Interest</option>
          <option value="16">Business Local Taxes</option>
          <option value="821">Cashback Reward</option>
          <option value="864">Commissions &amp; Fees</option>
          <option value="70">DELETE THIS?</option>
          <option value="55">Dental</option>
          <option value="872">Ebay Items</option>
          <option value="50">Estimated Taxes</option>
          <option value="18">Health Insurance</option>
          <option value="53">Medical Services</option>
          <option value="7">Mobile Internet</option>
          <option value="861">Office Rent</option>
          <option value="78">OTR MEALS - Dining</option>
          <option value="81">OTR Meals - Fast Food</option>
          <option value="855">Personal - Air Travel</option>
          <option value="67">Personal - ATM</option>
          <option value="866">Personal - Bank Fees</option>
          <option value="843">Personal - Bug Prevention</option>
          <option value="75">Personal - Car Insurance</option>
          <option value="845">Personal - Car Loan</option>
          <option value="69">Personal - Car Maintenance</option>
          <option value="847">Personal - Car Upgrades</option>
          <option value="72">Personal - Car Wash</option>
          <option value="66">Personal - Clothing</option>
          <option value="61">Personal - Dining</option>
          <option value="89">Personal - Dry Cleaners</option>
          <option value="92">Personal - Electric Bill</option>
          <option value="84">Personal - Entertainment</option>
          <option value="62">Personal - Fast Food</option>
          <option value="867">Personal - Fundrise Investment</option>
          <option value="60">Personal - Gasoline</option>
          <option value="63">Personal - Groceries</option>
          <option value="64">Personal - Haircuts</option>
          <option value="814">Personal - Home Insurance</option>
          <option value="68">Personal - Home Items</option>
          <option value="863">Personal - Home Maintenance</option>
          <option value="94">Personal - Home Security</option>
          <option value="811">Personal - Interest Payments</option>
          <option value="83">Personal - Landscaping</option>
          <option value="71">Personal - Licenses</option>
          <option value="95">Personal - Local Internet</option>
          <option value="97">Personal - Mailbox</option>
          <option value="844">Personal - Miscellaneous</option>
          <option value="76">Personal - Mortgage</option>
          <option value="876">Personal - Mutual Funds</option>
          <option value="862">Personal - Natural Gas</option>
          <option value="857">Personal - Phone Apps</option>
          <option value="819">Personal - Rental Car</option>
          <option value="65">Personal - Shopping</option>
          <option value="873">Personal - Transfers</option>
          <option value="46">Personal - Trash Disposal</option>
          <option value="851">Personal - Truck Upgrades</option>
          <option value="827">Personal - Uber and Taxi</option>
          <option value="885">Personal - Umbrella</option>
          <option value="93">Personal - Water Bill</option>
          <option value="98">Personal - Web Hosting</option>
          <option value="90">Personal - Wine</option>
          <option value="21">PO Box</option>
          <option value="54">Prescriptions</option>
          <option value="813">Property Taxes</option>
          <option value="822">Refunds</option>
          <option value="874">SBA Loan</option>
          <option value="840">State Permits</option>
          <option value="878">Trailer Repair</option>
          <option value="839">Truck 2290</option>
          <option value="849">Truck DACH</option>
          <option value="824">Truck Fuel</option>
          <option value="836">Truck IFTA</option>
          <option value="830">Truck Insurance</option>
          <option value="875">Truck Lumpers</option>
          <option value="832">Truck Maintenance</option>
          <option value="858">Truck Parking</option>
          <option value="834">Truck Payment</option>
          <option value="831">Truck Repairs</option>
          <option value="838">Truck SCAC</option>
          <option value="826">Truck Software</option>
          <option value="58">Truck Supplies</option>
          <option value="833">Truck Tolls</option>
          <option value="837">Truck UCR</option>
          <option value="825">Truck Wash</option>
          <option value="86">W2 Payroll (After Tax)</option>
        </select></td>
      <td class="bigtext" nowrap><input type="hidden" value="-4.63" name="amount[2]" />
        <font color="red">$-4.63</font>
      </td>

    </tr>
    <tr style="background-color:white;">
      <td class="bigtext"><input type="checkbox" value="1" name="chk[3]" checked="checked" onClick="toggleColour(this,'#FEAB2F');" /></td>
      <td class="bigtext">3</td>
      <td class=" bigtext"><input type="hidden" value="03/28/2025" name="date[3]" />03/28/2025</td>
      <td class="bigtext"><input type="text" size="56" value="VTC SERVICE" name="desc[3]" maxlength="190" style="border: none; padding: 4px; font-size: 12px;" /></td>
      <td class="bigtext"><select name="cat[3]">
          <option value="1" selected="selected">(**NO MATCH**)</option>
          <option value="829">(Work) Hotel Stay</option>
          <option value="818">(Work) Uber and Taxi</option>
          <option value="45">Accountant</option>
          <option value="850">Addon Asset</option>
          <option value="2">Bank Dividends</option>
          <option value="3">Bank Interest</option>
          <option value="16">Business Local Taxes</option>
          <option value="821">Cashback Reward</option>
          <option value="864">Commissions &amp; Fees</option>
          <option value="70">DELETE THIS?</option>
          <option value="55">Dental</option>
          <option value="872">Ebay Items</option>
          <option value="50">Estimated Taxes</option>
          <option value="18">Health Insurance</option>
          <option value="53">Medical Services</option>
          <option value="7">Mobile Internet</option>
          <option value="861">Office Rent</option>
          <option value="78">OTR MEALS - Dining</option>
          <option value="81">OTR Meals - Fast Food</option>
          <option value="855">Personal - Air Travel</option>
          <option value="67">Personal - ATM</option>
          <option value="866">Personal - Bank Fees</option>
          <option value="843">Personal - Bug Prevention</option>
          <option value="75">Personal - Car Insurance</option>
          <option value="845">Personal - Car Loan</option>
          <option value="69">Personal - Car Maintenance</option>
          <option value="847">Personal - Car Upgrades</option>
          <option value="72">Personal - Car Wash</option>
          <option value="66">Personal - Clothing</option>
          <option value="61">Personal - Dining</option>
          <option value="89">Personal - Dry Cleaners</option>
          <option value="92">Personal - Electric Bill</option>
          <option value="84">Personal - Entertainment</option>
          <option value="62">Personal - Fast Food</option>
          <option value="867">Personal - Fundrise Investment</option>
          <option value="60">Personal - Gasoline</option>
          <option value="63">Personal - Groceries</option>
          <option value="64">Personal - Haircuts</option>
          <option value="814">Personal - Home Insurance</option>
          <option value="68">Personal - Home Items</option>
          <option value="863">Personal - Home Maintenance</option>
          <option value="94">Personal - Home Security</option>
          <option value="811">Personal - Interest Payments</option>
          <option value="83">Personal - Landscaping</option>
          <option value="71">Personal - Licenses</option>
          <option value="95">Personal - Local Internet</option>
          <option value="97">Personal - Mailbox</option>
          <option value="844">Personal - Miscellaneous</option>
          <option value="76">Personal - Mortgage</option>
          <option value="876">Personal - Mutual Funds</option>
          <option value="862">Personal - Natural Gas</option>
          <option value="857">Personal - Phone Apps</option>
          <option value="819">Personal - Rental Car</option>
          <option value="65">Personal - Shopping</option>
          <option value="873">Personal - Transfers</option>
          <option value="46">Personal - Trash Disposal</option>
          <option value="851">Personal - Truck Upgrades</option>
          <option value="827">Personal - Uber and Taxi</option>
          <option value="885">Personal - Umbrella</option>
          <option value="93">Personal - Water Bill</option>
          <option value="98">Personal - Web Hosting</option>
          <option value="90">Personal - Wine</option>
          <option value="21">PO Box</option>
          <option value="54">Prescriptions</option>
          <option value="813">Property Taxes</option>
          <option value="822">Refunds</option>
          <option value="874">SBA Loan</option>
          <option value="840">State Permits</option>
          <option value="878">Trailer Repair</option>
          <option value="839">Truck 2290</option>
          <option value="849">Truck DACH</option>
          <option value="824">Truck Fuel</option>
          <option value="836">Truck IFTA</option>
          <option value="830">Truck Insurance</option>
          <option value="875">Truck Lumpers</option>
          <option value="832">Truck Maintenance</option>
          <option value="858">Truck Parking</option>
          <option value="834">Truck Payment</option>
          <option value="831">Truck Repairs</option>
          <option value="838">Truck SCAC</option>
          <option value="826">Truck Software</option>
          <option value="58">Truck Supplies</option>
          <option value="833">Truck Tolls</option>
          <option value="837">Truck UCR</option>
          <option value="825">Truck Wash</option>
          <option value="86">W2 Payroll (After Tax)</option>
        </select></td>
      <td class="bigtext" nowrap><input type="hidden" value="-1970.07" name="amount[3]" />
        <font color="red">$-1970.07</font>
      </td>

    </tr>
    <tr>
      <td>
        <p id="checkCount"> </p>
      </td>
    </tr>
  </table>
</form>

Alguma ideia de como consertar isso?

user26136009

Asked: 2025-03-08 12:13:34 +0800 CST

Analisar um arquivo CSV que pode ter colunas fora da ordem esperada

Eu uso a função fgetcsv() para dividir um arquivo .CSV em uma matriz para poder inserir os valores em um banco de dados.

O problema é que às vezes a corporação da qual eu baixo esses arquivos altera colunas em torno das quais altera o número do array. Aqui está um exemplo de um print_r do arquivo CSV:

Array ( [0] => Symbol [1] => Description [2] => Qty (Quantity) [3] => Price [4] => Price Chng % (Price Change %) [5] => Price Chng (Price Change ) [6] => Day Chng % (Day Change %) [7] => Day Chng (Day Change ) [8] => Cost Basis [9] => Gain % (Gain/Loss %) [10] => Gain (Gain/Loss ) [11] => Reinvest? [12] => Reinvest Capital Gains? [13] => Last Div (Last Dividend) [14] => Volume [15] => Security Type ) 
Array ( [0] => Test1 [1] => test desc [2] => 820 [3] => 19.505 [4] => -1.84% [5] => -0.365 [6] => -1.84% [7] => -300.37 [8] => 601.73 [9] => -18.4% [10] => -607.63 [11] => No [13] => 0.72025 [14] => 7041528 [15] => ETFs & Closed End Funds ) 
Array ( [0] => Test2 [1] => test desc again [2] => 110 [3] => 49.715 [4] => -1.83% [5] => -0.925 [6] => -1.76% [7] => -98.00 [8] => 95.2 [9] => -8.78% [10] => -526.55 [11] => Yes [14] => 28668328 [15] => ETFs & Closed End Funds ) 
Array ( [0] => Test3 [1] => test desc example [2] => 740 [3] => 21.71 [4] => -3.98% [5] => -0.9 [6] => -3.93% [7] => -657.59 [8] => 242.13 [9] => -20.63% [10] => -4176.73 [11] => No [13] => 2.0216 [14] => 2759846 [15] => ETFs & Closed End Funds )

Você pode ver que na segunda matriz há títulos como $column[0] é Símbolo e $column[3] é Preço.

[0] => Symbol [1] => Description [2] => Qty (Quantity) [3] => Price

Posso adicionar código para que $column[0] por exemplo sempre exiba o nome do símbolo? Se a corporação decidir adicionar uma coluna ou reorganizar as coisas, ela mudará a coluna Price para outra, como movê-la de $column[3] para $column[5]. Estou supondo que haja uma maneira de fazer com que ela pesquise qualquer chave que corresponda a uma coluna como Volume por exemplo, então qualquer chave que seja, ela poderia garantir que todas as chaves em cada matriz para Volume corresponderão a esse número de chave.

Eu estava apenas alterando manualmente os números da matriz quando eles fizeram isso, mas eles mudam muito, então estou pensando se posso adicionar algum código para onde a coluna Symbol seria sempre 0 e Price sempre estaria na coluna 3 e o mesmo se aplica a todos os nomes de coluna. Se eles forem reorganizados, eles ainda terão o mesmo número de antes?

Um pequeno exemplo do arquivo CSV:

"Symbol","Description","Qty (Quantity)","Price","Price Chng % (Price Change %)","Price Chng $ (Price Change $)","Day Chng % (Day Change %)","Day Chng $ (Day Change $)","Cost Basis","Gain % (Gain/Loss %)","Gain $ (Gain/Loss $)","Reinvest?","Reinvest Capital Gains?","Last Div (Last Dividend)","Volume","Security Type"
"Test1","ETF","820","$19.39","-2.42%","-$0.48","-2.42%","-$393.6","$601.73","-18.89%","-$3701.93","No","--","$0.72025","14,626,464","ETFs & Closed End Funds"
"Test2"," ETF","110","$49.43","-2.39%","-$1.21","-2.39%","-$133.1","$995.2","-9.31%","-$557.9","Yes","--","N/A","59,351,095","ETFs & Closed End Funds"
"Test3"," ETF","760","$21.77","-3.72%","-$0.84","-3.72%","-$638.4","$687.73","-20.02%","-$142.53","No","--","$2.0216","6,402,084","ETFs & Closed End Funds"

Caixas de seleção de contagem de Javascript não funcionam

Analisar um arquivo CSV que pode ter colunas fora da ordem esperada

Reformatar números, inserindo separadores em posições fixas

Por que os conceitos do C++20 causam erros de restrição cíclica, enquanto o SFINAE antigo não?

Problema com extensão desinstalada automaticamente do VScode (tema Material)

Vue 3: Erro na criação "Identificador esperado, mas encontrado 'import'" [duplicado]

Qual é o propósito de `enum class` com um tipo subjacente especificado, mas sem enumeradores?

Como faço para corrigir um erro MODULE_NOT_FOUND para um módulo que não importei manualmente?

`(expression, lvalue) = rvalue` é uma atribuição válida em C ou C++? Por que alguns compiladores aceitam/rejeitam isso?

Um programa vazio que não faz nada em C++ precisa de um heap de 204 KB, mas não em C

PowerBI atualmente quebrado com BigQuery: problema de driver Simba com atualização do Windows

AdMob: MobileAds.initialize() - "java.lang.Integer não pode ser convertido em java.lang.String" para alguns dispositivos

user26136009's questions