Verify if column contains letter

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.