Find Names between Delimiter

Hi Sherl ,

I am not sure for some respects about the string text, One respect, the mark1 'content as picture below is "NPO-63928320-Robert Robert James-Some wild text to confused-ALL CAPS VALUES-6/31/19-DAH" or "NPO-63928320-Robert Robert James-6/31/19-DAH"; the other respect, the string text is not regular in structure such as mark2 and mark3, for the irregular structure, it is not supported to get entire name as you need completely using DAX.

While, you can get name of regular structure string text by Spilt Column->By Delimiter ,spilt by "-" .

Then, return the result showing picture below, the column Name.3 returns part name.

Here is my test pbix file link: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EWB8lRsaBjlEuctkM9nsjckBtxP08jlhgR-owkZeNdVGfw?e=71JfL9

Best Regards,

Amy

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