Results 1 to 4 of 4

Power query filter rows by contains text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    630

    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.
    Attached Files Attached Files
    Last edited by Dicken; 10-19-2023 at 12:14 PM. Reason: attach doc

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] [Power Query] How to filter 0 from two columns in power query editor in one step?
    By daliye in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2023, 09:44 PM
  2. Filter rows in power query
    By Mayasak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2023, 02:09 AM
  3. [SOLVED] Power Query - add empty rows & rows of text below bottom of group
    By josephteh in forum Excel General
    Replies: 1
    Last Post: 11-16-2020, 02:59 PM
  4. [SOLVED] Power Query Filter All Rows After Prior Month
    By Tayque_J_Holmes in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-19-2018, 11:31 AM
  5. [SOLVED] Power Query / Get & Transform - filter text contains based on list
    By SHI.NL in forum Excel General
    Replies: 8
    Last Post: 05-14-2018, 04:53 PM
  6. [SOLVED] Power Query: Group by category, list text items on separate rows
    By JimDandy in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-05-2017, 12:11 AM
  7. Replies: 2
    Last Post: 07-19-2015, 06:04 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1