Question

14
Replies
1162
Views
voonkeongl Member since 2017 12 posts
Kelly Services Malaysia Sdn. Bhd.
Posted: July 11, 2018
Last activity: July 26, 2018
Closed

Filtering a report based on a substring of my own email address

Greetings

I have a simple report definition to retrieve the list of operator IDs. The only filter I have to apply is to show those records that have the same email address domain as my ID's.

Eg. the records are

1. abc@123.com

2. abc@456.com

3. dce@123.com

My email address is vk@123.com

So only record 1 and 3 should show. How do I achieve this? I tried using the right trim/sub string calculation builder in the "Value" column but am not clear how it works

Thanks

Reporting
Moderation Team has archived post
Share this page LinkedIn