Forum Discussion

tomekm's avatar
tomekm
Icon for Helper III rankHelper III
4 years ago
Solved

Split a mixed data type column into hyperlink and text

Hello,   I have an excel column (lets call it: “more info”) that contains rows with mixed data: text and hyperlinks in each cell. When imported into Power BI, I would like to split the “more info” ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

     Hi tomekm 

    In the situation, you can use Power BI Split Columns option to split that column into multiple columns.Please refer to the following document to see if it helps you.

    https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

     

    Best Regards

    Community Support Team _ Polly

     

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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Agreed, a sample dataset would be nice.  If you can identify a reliable delimeter then it's pretty straightforward and could be done in Power Query.  Even without a consistent delimiter there could still be some options in PowerQuery or DAX.

tomekm's avatar
tomekm
Icon for Helper III rankHelper III
4 years ago

Here is the sample data:

 

Folder Path

SubjectImportanceHasAttachments"More info" column:
\Calendar\ABC meetingNormalFalseMeeting minutes <<<<<<<< (this is the hyperlink)  
>>>>>> this is the text: Join the meeting to discuss important topics…..