Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter a List by Character - List of Columns

Hi,

 

I'm creating a list of all Columns in my query. I would like to filter this list to only show Columns that contain a particular character in the Column Header name.

 

I've able to get a list of all Columns using the following:

 

= Table.ColumnNames(#"Trim Text and Join to Last Split Step")

 

I want to filter my list to only show fields that contain ".". In the following step, I'm able to filter the list to only show fields with an extact match:

 

= List.Select(Table.ColumnNames(#"Trim Text and Join to Last Split Step"), each _ = "Campaign.Campaign")

 

But I want to be able to use Contains somewhere here to I can return more fields.

 

Any ideas on how I can achieve this in one step?

 

Thanks,

Mark

  • Hi Anonymous 

     

    You can use this

    = List.Select(Table.ColumnNames(#"previous step name"), each Text.Contains(_, "."))

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support

    Hi Anonymous 

     

    You can use this

    = List.Select(Table.ColumnNames(#"previous step name"), each Text.Contains(_, "."))

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.