1. let
    2.     源 = Folder.Files(获取路径("农业银行流水明细")),
    3.     合并的二进制 = Binary.Combine(源[Content]),
    4.     #"导入的 CSV" = Csv.Document(合并的二进制,[Delimiter=",", Columns=1, Encoding=936, QuoteStyle=QuoteStyle.None]),
    5.     筛选的行 = Table.SelectRows(#"导入的 CSV", each Text.StartsWith([Column1], "2018")),
    6.     已添加自定义 = Table.AddColumn(筛选的行, "支付日期", each Date.FromText(Text.Middle([Column1], 0, 8))),
    7.     已添加自定义1 = Table.AddColumn(已添加自定义, "支付时间", each Time.FromText(Text.Middle([Column1], 9, 6))),
    8.     已插入文本范围 = Table.AddColumn(已添加自定义1, "付款银行", each Text.Middle([Column1], 38, 10), type text),
    9.     去除的文本 = Table.TransformColumns(已插入文本范围,{{"付款银行", Text.Trim, type text}}),
    10.     插入的文本长度 = Table.AddColumn(去除的文本, "长度", each Text.Length([付款银行]), Int64.Type),
    11.     已添加条件列 = Table.AddColumn(插入的文本长度, "支付金额", each if [长度] = 0 then Text.Middle([Column1], 58, 11) else if [长度] = 4 then Text.Middle([Column1], 54, 11) else if [长度] = 6 then Text.Middle([Column1], 52, 11) else if [长度] = 7 then Text.Middle([Column1], 51, 11) else if [长度] = 8 then Text.Middle([Column1], 50, 11) else if [长度] = 9 then Text.Middle([Column1], 49, 11) else if [长度] = 10 then Text.Middle([Column1], 48, 11) else "未配置"),
    12.     已添加条件列2 = Table.AddColumn(已添加条件列, "手续费", each if [长度] = 0 then Text.Middle([Column1], 69, 11) else if [长度] = 4 then Text.Middle([Column1], 65, 11) else if [长度] = 6 then Text.Middle([Column1], 63, 11) else if [长度] = 7 then Text.Middle([Column1], 62, 11) else if [长度] = 8 then Text.Middle([Column1], 61, 11) else if [长度] = 9 then Text.Middle([Column1], 60, 11) else if [长度] = 10 then Text.Middle([Column1], 59, 11) else "未配置"),
    13.     已添加条件列3 = Table.AddColumn(已添加条件列2, "支付流水号", each if [长度] = 0 then Text.Middle([Column1], 80, 12) else if [长度] = 4 then Text.Middle([Column1], 76, 12) else if [长度] = 6 then Text.Middle([Column1], 74, 12) else if [长度] = 7 then Text.Middle([Column1], 73, 12) else if [长度] = 8 then Text.Middle([Column1], 72, 12) else if [长度] = 9 then Text.Middle([Column1], 71, 12) else if [长度] = 10 then Text.Middle([Column1], 70, 12) else "未配置"),
    14.     已添加自定义2 = Table.AddColumn(已添加条件列3, "支付方式", each "农行转账"),
    15.     删除的其他列 = Table.SelectColumns(已添加自定义2,{"支付流水号", "支付日期", "支付时间", "付款银行", "支付金额", "手续费", "支付方式"}),
    16.     更改的类型 = Table.TransformColumnTypes(删除的其他列,{{"支付日期", type date}, {"支付时间", type time}, {"付款银行", type text}, {"支付金额", type number}, {"支付方式", type text}, {"支付流水号", type text}, {"手续费", type number}}),
    17.     去除的文本1 = Table.TransformColumns(更改的类型,{{"支付流水号", Text.Trim, type text}})
    18. in
    19.     去除的文本1