Power Query - Filtering question

Hello everyone,

I am recently start discoviring the Power Query and maybe its easy but I couldnt figure it out.

So, I am trying to filtering a column which is called "Business Tittles". I want to exclude "Intern" tittles but when I do "add conditional column" and "contains" option, Its also deleting the tittles which contains "International" as well. For example there are "International Marketing Manager" tittle. I want to keep that one inside.

I think I need to write something in " Add custom column" some IF formulas which I can remove "Intern" tittles but keep the "international"

Could you please help me on that ?

Thank you very much
Orhan

To attach an Excel file to your post,

• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

Originally Posted by xlnitwit

Hi,

You can add spaces at the beginning and end of the field and search for " intern " like this
Text.Contains(" " & [Field name] & " ", " Intern ")
It would probably be sensible to convert to all upper or lower case too to make the check case insensitive.

Thank you very much. It worked perfect ! Appreciated it.