The code below is being read from a database. I want to remove the span tags before it is displayed on the screen, i however want to keep all other tags such as <p>
<SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><p>the road<p/></SPAN>
Im using the following code:
txt = your span content
txt = Right(txt,Len(txt) - Instr(txt,">")) ' positon of first occurance of ">"
txt = Left(txt,Instr(txt,("</SPAN"))-1)
But keep gettin the error: Invalid procedure call or argument 'Left'
can somebody please tell me a way to fix this problem