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

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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