Remove code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi My Name is Lloyd

I have linked a Surveys done in SharePoint to Access as a linked table, but
in one of my fields I get This <div>lloyd and Lance</div>

I want to remove the HTML Code <div> and </div>

Please help

Thanks
 
1- If it always starts and ends with these character you could use the left()
and Right to remove the string

2- you could use the replace() to find and replace '<div>' and '</div>' with
""

Daniel
 
Back
Top