|
楼主 |
发表于 2019-4-17 17:40
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
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两段的意思么? |
|