飞天篮球

边齐
第 3 位会员
注册于 2018-08-08 14:57:03
活跃于 2020-04-01 16:24:24


  • 城市
  • PQ 在分隔符后加提取字段用什么函数 at 2018-08-15 22:48:56
    = Table.AddColumn(源,"a",each Text.Replace([str],"-",[ x = List.LastN(Text.SplitAny([str],Text.Combine({"A".."z","-"})),2), 
                                                           y = List.Transform(x,Text.Length),
                                                           z = "-"&Text.Start(x{0},y{0}-y{1})] [z]))

    file