Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
replace(replace(MyField, '<div>',''),'</div>','') as MyField
replace(replace(MyField, '<div>',''),'</div>','') as MyField