Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove <div> & <div>  from XML Data from sharepoint

Hi Friends

I am importing data from sharepoint using xml, However after importing it is adding <div> &  <div>  inside the data and mutiple and different positions.

for ex:<div>Mix up delivery, instead of putting Edith in the parcel supplier <div>put klaipeda hence our agent in Rotterdam <div>delivered it to Klaipeda.</div> <div> </div>

Please let me know how we can aviod <div> &  <div>  at the script level.

Many thanks!

Rahul

1 Solution

Accepted Solutions
Gysbert_Wassenaar

replace(replace(MyField, '<div>',''),'</div>','') as MyField


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

replace(replace(MyField, '<div>',''),'</div>','') as MyField


talk is cheap, supply exceeds demand