Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Is it possible extract email addresses from incident thread in OSvC — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is it possible extract email addresses from incident thread in OSvC

Accepted answer
29
Views
8
Comments
edited Oct 24, 2018 10:17AM in Reporting & Analytics for B2C Service 8 comments

Summary

Extract email addresses from incident thread

Content

Hi,

I need to extract email addresses from multiple incidents (all sent from the same email address) but with different threads (it basically is a webform our customers send the unsubscribe requests through which then arrive as incidents in OSvC).

I know it is possible to do it in Excel, so I can simply create a report with all the threads, export it and use a formula, but was wondering whether it would be possible directly in the report in OSvC?

The excel formula that works is (threads in column A): =TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND(" ",A2&"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!