Forum Discussion
Solved
Verify if column contains letter
Hello altruists, How to verify in Power Query if certain column contains letters ( from A to Z ) ? Thank you in advance.
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.
Thank 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.
Hi sparvez
You can add a custom column with below code.
Text.Length(Text.Select([Column1],{"A".."Z"}))>0
If you want it to ignore case, you can use
Text.Length(Text.Select([Column1],{"A".."Z","a".."z"}))>0
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
This doesn't work
Expression.Error: We cannot convert a value of type Record to type Text.
Details:
Value=
serial=AEA413
