Forum Discussion
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...
Text.Combine(Splitter.SplitTextByCharacterTransition({"a".."z"},{"A".."Z"})("SmithJ")," ")
Yes thanks. I already detected the Mc issue but hadnt thought of Mac.