Forum Discussion
johnlhaase
2 years agoHelper I
Identifying All Uppercase letters in a column
Hello What is the M code for identifying a row/record with all uppercase letters? Thanks John Haase
johnlhaase
2 years agoHelper I
Hello here is the solution that works for my sitution. You can subsitute {0..9} or lower upper case in the {..}
= Table.AddColumn(#"Renamed Columns1", "New", each Text.Select([Name], {"a".."z"}))
Thanks