回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有基本的脚本知识,但我不知道如何处理这个问题。我正在尝试将我的银行自动生成的CSV文件转换成YNAB(你需要一个预算)可以理解的格式。你知道吗</p>
<p><strong>YNAB格式(所需的csv文件格式)</strong></p>
<pre><code>Date,Payee,Category,Memo,Outflow,Inflow
07/25/10,Sample Payee,,Sample Memo for an outflow,100.00,
07/26/10,Sample Payee 2,,Sample memo for an inflow,,500.00
</code></pre>
<p><strong>银行格式(csv文件的当前状态)</strong></p>
<pre><code>"Account Type","Account Number","Transaction Date","Cheque Number","Description 1","Description 2","CAD$","USD$"
Chequing,00401-1234567,8/19/2013,,"Transfer","WWW TRANSFER - 0645 ",50.00,,
Chequing,00401-1234567,8/19/2013,,"STARBUCKS AC. U","IDP PURCHASE - 6678 ",-1.94,,
</code></pre>
<p>(全部为假数据)</p>
<p>如何将当前的CSV文件转换为所需的格式?你知道吗</p>