将CSV文件写入yaml文件?
问题描述:
想知道是否有人可以帮我输出这个yaml文件?将CSV文件写入yaml文件?
由于目前它只写入返回到yaml文件的最后一个数组。
require 'csv'
require 'yaml'
#fp = File.open("vatsim-row.txt")
CSV.foreach("vatsim-data.txt", :col_sep =>':', :row_sep =>:auto, :quote_char => ":") do |row|
if (row[3] == "PILOT") and (row[13]=="EIDW" or row[13]=="EICK" or row[13]=="EINN" or row[13]=="EIKN" or row[13]=="EIDL" or row[13]=="EICM" or row[13]=="EIKY" or row[13]=="EISG" or row[13]=="EIWF" or row[13]=="EIWT" or row[11]=="EIDW" or row[11]=="EICK" or row[11]=="EINN" or row[11]=="EIKN" or row[11]=="EIDL" or row[11]=="EICM" or row[11]=="EIKY" or row[11]=="EISG" or row[11]=="EIWF" or row[11]=="EIWT")
p row
p row.count
File.open("pilots.yml", "w") {|f| f.write(row.to_yaml) }
elsif row[3] == "ATC" and (row[0].slice(0, 3) == "EGC" or row[0].slice(0, 3) == "EID" or row[0].slice(0, 3) == "EIC" or row[0].slice(0, 3) == "EIN" or row[0].slice(0, 3) == "EIK" or row[0].slice(0, 3) == "EIS" or row[0].slice(0, 3) == "EIW" or row[0].slice(0, 3) == "EIM")
p row
p row.count
end
end
排序输出我正在寻找在YAML文件:
---
clients:
callsign: RYR87LN
cid: "123456"
name: Joe Blogs EIDW
type: PILOT
lat: "48.28681"
long: "-4.03478"
altitude: "30883"
groundspeed:"438"
aircraft: B738
p_cruise: "300"
dep: LFRS
p_alt: FL310
arr: EIDW
server: EUROPE-C2
pro_rev: "100"
rating: "1"
squawk: "2200"
facilitytype:
vis_range:
p_flighttyp: "0"
route: FPL-RYR87LN-IS-B738/M-ZSRWY/S-REG/EI-DAH COM/TCAS RVR/200 OPR/RYRVIRTUAL.COM DOF/110813- A/BLUE/WHITE/YELLOW /V/ TERPO UM616 KORER UN482 DEGEX UN490 BERAD UM142 INSUN UN34 EVRIN N34 BUNED
atismsg:
lt_atis:
logon: "20110813151905"
heading: "310"
qnh_ig: "29.79"
qnh_mb: "1008"
如果任何人都可以在方向指向我,将是巨大的!
答
您需要打开文件进行追加。使用模式w
打开一个文件会将其截短为0,这样您就可以在循环的每次迭代中覆盖它。
使用此:
File.open("pilots.yml", "a") {|f| f.write(row.to_yaml) }
更重要的是,保留文件打开追加通过了方案,而不是重复打开和关闭它。那么你可能会要截断文件:
File.open("pilots.yml", "w") do |f|
CSV.foreach("vatsim-data.txt", :col_sep =>':', :row_sep =>:auto, :quote_char => ":") do |row|
# ...
f.write(row.to_yaml)
# ...
end
end
这是完美的伎俩感谢做了磨@Meagar。 而且想到这么简单! –