Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Normalization text Name

Can one of you help me figure out how to normalize this data so only the name will show up   Thank You. Greatly appreciate     i:0#.w|qnet\John.doe i:0#.w|qnet\John.smith i:0#.w|qnet\bo...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may create a column like DAX below.

     

    Extract Name = RIGHT([Text],LEN([Text])-FIND("\",[Text],1,0))

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Anonymous ,

 

You may create a column like DAX below.

 

Extract Name = RIGHT([Text],LEN([Text])-FIND("\",[Text],1,0))

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.