Sort by If Contains?

[jwlam]

Hi everyone,

I'm trying to sort my data by if the email address contains a company's name or not. But the Sort tool doesn't really work for that and I'm not looking to filter it out either. I want all the data to stay together just sorted so end users can see internal vs external clients in the reports more easily. 

In the example below I'd like the Internal email addresses to be sorted by if it contains "Internal" and be on top of the other emails that don't contain "Internal".

Original Data

First Name	Last Name	Email
Abe	Lincoln	Abe.Lincoln@Internal.com
Jane	Doe	Jane.doe@External.com
John	Smith	John.Smith@Internal.com
Tom	Jefferson	Tom.Jefferson@External.com

Desired Result

First Name	Last Name	Email
Abe	Lincoln	Abe.Lincoln@Internal.com
John	Smith	John.Smith@Internal.com
Jane	Doe	Jane.doe@External.com
Tom	Jefferson	Tom.Jefferson@External.com

Thanks!

[DataNath · Accepted solution]

Would this work @jwlam? Just creates a flag where internal is lower than external and so when you sort ascending on the flag they'll all sit at the top. I can't think of any way to do the contains check and sort in one.

[jwlam]

@DataNath That worked perfectly. Thanks!