Forum Discussion

sparvez's avatar
sparvez
Icon for Helper I rankHelper I
3 years ago
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.
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

sparvez's avatar
sparvez
Icon for Helper I rankHelper I
3 years ago

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.

 

ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
3 years ago

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.