更新时间:2023-12-03 20:31:05
let
file_path = "C:\your_path\csv.txt",
file = File.Contents(file_path),
src = Lines.FromBinary(file),
skip = List.Skip(src,6),
combine = Text.Combine(skip, "#(lf)"),
csv = Csv.Document(combine),
promote = Table.PromoteHeaders(csv)
in
promote