Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Advanced searching within column text function wanted. Possible?

Hello all,

 

I am looking for something that is (I think) pretty advanced. I hope to hear from some great minds here if it is possible, and if yes, how?

 

Here is some easy sample data: https://www112.zippyshare.com/v/jOVh0GAu/file.html

Or here if the link does not work: https://filebin.net/9dqymvfrbafnumw3

 

The problem

In the data we see two columns, one which contains a call number, and one with a lot of strings all in one cell. In this cell we see a sample conversation between 3 persons. The middle persons says '#callcoaching'. This is the string I want to extract.

 

But not only that. I want to see who (the name) of the person who has said '#callcoaching', and the name of the first person that has initiated the call (the one that the coaching is meant to). The third one is just there to represent the real data, since the cells contain much more information than just 3 persons. There are dates and times before the names, these can be deleted if possible.

 

I want to show the total amount of instances where people have said the words '#callcoaching', which people are the most 'coached' (the first persons/call initiators) and which people use this phrase the most. I think we therefore need the have the data in separate columns, but I am not sure.

 

I have no idea if this is possible, but I hope someone here has an idea if this is doable in DAX or R or M or something.

 

Thanks for your time and effor.

AliBI

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion

    Hi Anonymous 

    Can not access your sample, is there any chance that you could share it any other way?

     

    Many Thanks 

    Mariusz