Begins with filter type
The Begins with filter checks if a field starts with the specified characters or substring.
It’s like asking: “Does this value start with ___?”
Example:
Let’s say you’re working with a list of campaign names like:
-
PROMO_Summer
-
PROMO_Q2
-
TXN_Invoice
-
TXN_Shipping
If you apply:
-
Filter: Begins With
-
Value:
PROMO
Result:
-
PROMO_Summer
✅ -
PROMO_Q2
✅ -
TXN_Invoice
❌
This is especially helpful when:
-
Filter records by prefix-based naming (e.g., all campaigns starting with “Q3_” or “TEST_”)
-
Identify emails starting with a company prefix (e.g.,
internal_
) -
Match SKUs or codes that follow a consistent pattern (e.g.,
PRD001
,PRD002
, etc.)
Ends with filter type
The Ends with filter checks if a field finishes with the specified characters or substring.
It’s like asking: “Does this value ends with ___?”
Example:
-
Working with email addresses:
-
jane.doe@gmail.com
-
john@company.com
-
alex@yahoo.co.uk
Apply:
-
Filter: Ends With
-
Value:
gmail.com
Result:
-
jane.doe@gmail.com
✅ -
john@company.com
❌ -
alex@yahoo.co.uk
❌
-
This is especially helpful when:
-
Match email addresses by domain (e.g.,
Ends With "gmail.com"
) -
Find file names or URLs ending in certain formats (e.g.,
.pdf
,.jpg
) -
Identify customer codes or reference numbers ending in specific digits or tags
Available for field types: Text, EmailAddress, Phone, Locale
To know more on how to use these filter types, you can watch this video.
Comments
0 comments
Please sign in to leave a comment.