这样的判断替换逻辑用M该如何写？

suye1010 · 发表于 2021-8-12 17:47

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Added Custom" = Table.AddColumn(Source, "Custom", each
      let
         tempa=Splitter.SplitTextByDelimiter("/")([Text])
      in
         Text.Combine(List.Accumulate(List.Positions(tempa),tempa,(s,c)=> List.Range(s,0,c+1)&List.Transform(List.Range(s,c+1),each Replacer.ReplaceText(_,Splitter.SplitTextByCharacterTransition({"A".."Z"},{"0".."9"})(tempa{c}){0},""))),"-"))
in
#"Added Custom"

xzlu13014 · 发表于 2021-8-13 17:46

本帖最后由 xzlu13014 于 2021-8-13 17:48 编辑

="KE0123"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A3,"/","-"),"KE0123",""),"KE","") 如果只是这个开头这个办法应该很快

		自动登录	找回密码
密码			免费注册

[已解决] 这样的判断替换逻辑用M该如何写？