回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我正在尝试将复制/粘贴的文本转换为csv,这样我可以在之后拆分。
问题是里面有空白标签,我似乎无法去掉</p>
<p>复制/粘贴示例:</p>
<pre><code>Amarr Hybrid Tech Decryptor 12 Decryptors - Hybrid 12 m3
Ancient Coordinates Database 23 Sleeper Components 2.30 m3
Caldari Hybrid Tech Decryptor 17 Decryptors - Hybrid 17 m3
Carbon 17 General 34 m3
Cartesian Temporal Coordinator 4 Ancient Salvage 0.04 m3
Central System Controller 2 Ancient Salvage 0.02 m3
</code></pre>
<p>现在我想得到这样的东西:</p>
<pre><code>Amarr Hybrid Tech Decryptor,12,Decryptors - Hybrid,12,m3,
Ancient Coordinates Database,23,Sleeper Components,2.30,m3,
Caldari Hybrid Tech Decryptor,17,Decryptors - Hybrid,17,m3,
Carbon,17,General,34,m3,
Cartesian Temporal Coordinator,4,Ancient Salvage,0.04,m3,
Central System Controller,2,Ancient Salvage,0.02,m3,
</code></pre>
<p>(将始终是每行5个分隔符</p>
<p>我试着用不同的方法
<a href="https://stackoverflow.com/questions/4071396/split-by-comma-and-strip-whitespace-in-python">Split by comma and strip whitespace in Python</a>
但我似乎无法让它工作。</p>
<pre><code>@login_required
def index(request):
if request.method == "POST":
form = SellListForm(request.POST)
if form.is_valid():
selllist = form.save(commit=False)
selllist.user = request.user
string = selllist.sell
string = [x.strip() for x in string.split(',')]
print string
return HttpResponseRedirect(reverse('processed'))
else:
form = SellListForm()
return render(request, 'index.html', {'form': form})
</code></pre>
<p>回报</p>
<pre><code>[u'&lt;&lt;&lt;SULTS STUFF&gt;&gt;&gt;\t\t\tVoucher\t\t\t0 m3\r\nAmarr Hybrid Tech Decryptor\t12\tDecryptors - Hybrid\t\t\t12 m3\r\nAncient Coordinates Database\t23\tSleeper Components\t\t\t2.30 m3\r\nCaldari Hybrid Tech Decryptor\t17\tDecryptors - Hybrid\t\t\t17 m3\r\nCarbon\t17\tGeneral\t\t\t34 m3\r\nCartesian Temporal Coordinator\t4\tAncient Salvage\t\t\t0.04 m3\r\nCentral System Controller\t2\tAncient Salvage\t\t\t0.02 m3']
</code></pre>