Forum Discussion
Power Query Text.StartsWith() range of values
Hi, I would like to filter my data in the TableName table by the following condition: select data where column Code starts with V[2-9] OR M[2-9] OR contains ("MS" OR "PO"). That means that I wan...
Hi Anonymous ,
Not super nice, but this one maybe?
= Table.SelectRows ( Source, each ( Text.Contains ( [Code], "MS" ) ) or ( Text.Contains ( [Code], "PO" ) ) or ( ( Text.StartsWith ( [Code], "V" ) or Text.StartsWith ( [Code], "M" ) ) and List.Contains( {"2","3","4","5","6","7","8","9"},Text.At([Code] , 1 ) ) ) )/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hi Anonymous ,
Not super nice, but this one maybe?
= Table.SelectRows ( Source, each
( Text.Contains ( [Code], "MS" ) ) or
( Text.Contains ( [Code], "PO" ) ) or
( ( Text.StartsWith ( [Code], "V" ) or Text.StartsWith ( [Code], "M" ) )
and List.Contains( {"2","3","4","5","6","7","8","9"},Text.At([Code] , 1 ) ) )
)
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/