|
楼主 |
发表于 2019-4-17 17:40
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
let
Source = Csv.Document(File.Contents("txt文件存放路径"),[Delimiter="|"]),
Custom1 = Table.TransformColumns(Table.Combine(List.Transform(Table.Split(Source,9),Table.Transpose)),{},each List.Last(Text.Split(_,":"))),
Custom2 = Table.FromColumns(Table.ToColumns(Custom1),{"Name","Address","Tel No/s","Email Address","Website","Official Representative","Status","License Validty","x"}),
Custom3 = Table.RemoveColumns(Custom2,"x")
in
Custom3
大神,能帮我理解一下Source和Custom1两段的意思么? |
|