擅长:python、mysql、java
<p>如果这是你必须经常做的事情,并且你想让这个过程完全自动化,我想最简单的方法就是使用Python解析文件,然后使用<a href="http://docs.python.org/2/library/csv.html" rel="nofollow">csv Python module</a>写入csv。在</p>
<p>您的代码可能看起来像这样:</p>
<pre><code>with open("datafile.txt") as f:
hotel_data = []
for line in f:
# Let's make sure the line not empty
if line:
if "new hotelData();" in line:
if hotel_data:
write_to_csv(hotel_data)
hotel_data = []
else:
# Data, still has ending quote and semi colon
data = line.split("= ")[1]
# Remove ending quote and semi colon
data = data[:-2]
hotel_data.append(data)
def write_to_csv(hotel_data):
with open('hotels.csv', 'wb') as csvfile:
spamwriter = csv.writer(csvfile, delimiter=',',
quotechar='""', quoting=csv.QUOTE_MINIMAL)
spamwriter.writerow(hotel_data)
</code></pre>
<p>请注意,我还没有测试过这段代码,它只是为了帮助您并为您指出正确的方向,它不是完整的解决方案。在</p>