Power query filter rows by contains text

Hi,

Simple table with added custom ;

 Table.AddColumn(Custom1, "Custom", each Text.Contains( [Column1], "a" )
or Text.Contains([Column1] , "t") )

Not sure if this is best way but it does give a correct result , if there better ways involving List.ContainsAny etc please let me know.

But what i was trying to do was filter by these true /false so;

 Table.SelectRows(  Custom1, each Text.Contains( [Column1], "a" ) or Text.Contains([Column1] , "t") )

this returns only one row that is correct and an extra, not sure why the above does not like 't' when changed to 'x" it works but still xtra row?

Any help?

Book attached with attempts including Textpositionof .

Richard.

Richard,
No file attached. I am a bit confused by what you want to show in the "New Column". Do you need an if - then statement? Perhaps a mocked up solution also would help.

Not sure why you can't get the attached file, I just downloaded the attachment? just to note there is not excel table, it's all in power query.

I don't what new column, the add column was just shown to as example of true / false results to then use in table select rows
to filter down the table.

so ;

Table.SelectRows(Custom2, each ([Custom] = true))

I have found that if I use 'try' inside table select rows it works. that my be a future question as I'm not sure why it's needed?

Table.SelectRows(  Custom1, each 
Text.Contains( [Column1], "a" )
or Text.Contains([Column1] , "t")
  )

to;

Table.SelectRows(  Custom1, each 
try
Text.Contains( [Column1], "a" )
or Text.Contains([Column1] , "t") otherwise null 
  )

Richard.