Forum Discussion

messengineer2's avatar
messengineer2
Frequent Visitor
4 years ago
Solved

Detecting position of Case Change within a String in Column of data

Hi All. I have a series of thousands of User Names in a table column and the format is inconsistent and I am cleaning them up in M.  So I am replacing things like "." with " " or "," with "" or cha...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    Text.Combine(Splitter.SplitTextByCharacterTransition({"a".."z"},{"A".."Z"})("SmithJ")," ")

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
4 years ago

Text.Combine(Splitter.SplitTextByCharacterTransition({"a".."z"},{"A".."Z"})("SmithJ")," ")