About Jeff Allen Expertise I can answer basic to intermediate questions related to Classic ASP.I can answer Intermediate to Advanced questions CSS& HTML, and basic questions about JavaScript and Ajax. I can also answer questions related to web page accessibility under US Section 508.
Experience I have 8 years experience with HTML. I have been developing in ASP, VBScript and CSS for two years each. I also currently work as web developer.
Organizations IWA-HWG
Education/Credentials I have a BA in English with minors in Web Design and Scientific and Technical Writing
Expert: Jeff Allen Date: 7/17/2006 Subject: Trim text in DB when displaying as HTML
Question Hi,
I use ASP to scrape the contents of a webpage and store it in a database(the source site only updates once a week so to avoid lumbering them with requests I store it locally, and only update once a week). The asp script i have checks the dates and if an update is required it goes off and fetches it and stores it, if not, it creates a recordset and displays the latest info in the DataBase.
This all works fine, but when it stores the html content it also stores a lot of tables and frames from the original site which i dont use.
Is there a way with ASP to display information between two known delimiters? for instance:
In the text "I am a happy person" if I set "am" as start and "person" as end to display "a happy"
Long question for a (probably) easy task
Grateful for any help
Answer Yeah to do this you would use the MID function in ASP.
So, using your example, if you knew the starting position of what you wanted to grab, and the length of the string you wanted to grab you could do it this way:
<%
Dim myString : myString = "I am a happy person"
Dim storedString = Mid(myString, 5,7)
%>
