Sharepoint connecter Beta2

[Anonymous]

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.

[mahoneypat]

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

Regards,

Pat

[Anonymous]

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>