Verify if column contains letter

Hi sparvez ,

*BUMP* Bumping this post as it seems to be invisible 🙂

You could try something like this:

not List.IsEmpty(
    List.Intersect(
        {
            {"A".."Z"},
            Text.ToList([YourStringColumn])
        }
    )
)

Pete

Hi sparvez ,

You can try splitting your values, according to this solution by RickdeGroot 

Description of solution

Using the above technique, I created the example further below:

• pqInputData is a table with one colum which contains the data you want to check.
  • The column header is "Data"
  • The data in this example contain letters, strings, and numbers. 
• listLetterstoCheckFor is the list of letters or strings that you want to check for

The solution will first split your data by the values in list 'listLettersToCheckFor'. 

It will then create a second column with a count of the lists obtained in the first step. If the count is greater than 1, then the letter occurred in your original data. 

Finally, the solution filters on all the rows where your original data contain the sought letter. 

By adapting 'listLettersToCheckFor' to what you need, you have your own solution. 

Data: 

Source table 'pqInputData' represents the table below, where "Data" is the column header:

Data

listLettersToCheckFor = { "a" }  //case-sensitive

Solution:

Query pqCheckForLetters has the following code: 

let
Source = pqInputData,
#"Split text by delimiter" = Table.AddColumn(Source, "Splitter", each Splitter.SplitTextByAnyDelimiter(listLettersToCheckFor) ([Data])),
#"Count nbr of split items" = Table.AddColumn(#"Split text by delimiter", "CountSplitter", each List.Count([Splitter])),
#"Items with sought letter" = Table.SelectRows(#"Count nbr of split items", each [CountSplitter] > 1)
in
#"Items with sought letter"

If you like this answer, please accept it as solution. 

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,

If you want to check for any letter, you can simply modify my above solution by setting:

listLettersToCheckFor = { "A" .. "Z"}

The solution will work immediately. 

Since it has only 3 steps (or even just 2 if you combine them), it is already quite simple.

You could also make a custom function out of the above which returns TRUE or FALSE.