Forum Discussion
Helper IVerify if column contains letter
Hi sparvez
You can add a custom column with below code.
Text.Length(Text.Select([Column1],{"A".."Z"}))>0If you want it to ignore case, you can use
Text.Length(Text.Select([Column1],{"A".."Z","a".."z"}))>0Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Helper IThank you all , but is there any simple way to do this ? I just want to verify whether contains any of 26 letters of English Alphabet.
v-jingzhangCommunity Support
Hi sparvez
You can add a custom column with below code.
Text.Length(Text.Select([Column1],{"A".."Z"}))>0If you want it to ignore case, you can use
Text.Length(Text.Select([Column1],{"A".."Z","a".."z"}))>0Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
rusgesigHelper IV
This doesn't work
Expression.Error: We cannot convert a value of type Record to type Text.
Details:
Value=
serial=AEA413
ronrsnfldSuper User
Your question is very vague. The more information you provide, the better result you will obtain. For example, a "simple" method would be to visually scan the column until you see a letter; if you do then you have verified one is present.
Providing a representative data sample as text which can be copy/pasted, and at least a screenshot of your expected outcome, might result in a more focused suggestion.