cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Sharepoint connecter Beta2

Good day:

Outstanding - the option to connect to the defualt view.

But

Text box data is still being desplayed as follows:
<div class="ExternalClass628AFAA1914A435A8618F3CAD921FA9C"><p>One of groceries  <br></p></div>

I dont know of a way to transform this data correctly. Only the red should be visable.

2 REPLIES 2
Super User IV
Super User IV

On the Transform tab, you can use Extract Text Between Delimiters and use <p> and <br> as the delimiters

Regards,

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thanks for the suggestion but the output is diffrent for each eantry:

 

<div class="ExternalClassA2B2634292FD4A2EBE94997079B837EA">CLOVER ORANGE NECTAR JUICE -500ml<span id="ms-rterangecursor-start"></span><span id="ms-rterangecursor-end"></span></div>

 

<div class="ExternalClass57494869E3214A98962503ED16E40B3B">PNP CHICKEN STRIPS SALT<span id="ms-rterangecursor-start"></span><span id="ms-rterangecursor-end"></span> &amp; PEPPER 250GR </div>

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors