Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

Need Help

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

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

    Regards,

    Pat

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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>