How to Extract sentences in ASP based on keyword array?

Discussion in 'C#' started by mrkhm, Feb 23, 2010.

  1. #1
    Hello all,

    Thank you for reading my request for help...

    I'm looking for help from anyone who knows asp classic pretty well.

    I am trying to write code in ASP classic that will extract sentences from a 'memo' or 'text' field based on that sentence containing keywords and re-insert into next column in database only the sentences that contain the keywords.

    This is the code i am trying to implement:

    keywordarray = (keyword1, keyword2, keyword3, keyword4, keyword5, keyword6, etc....)

    set connection and drivers etc...
    sql = Select thiskey, thisfield from thistable
    connect and open sql etc....

    if not objrs.eof then

    split objrs("thisfield") into sections by "."

    for each section that has been split by "." find any secions which contain any of the keywords from "keywordarray"

    Join all of the sections that has been split by "." that contain the keywords from "keywordarray" and then re-insert this new data into new column in thistable where thiskey = objrs("thiskey").....

    any help..?
     
    mrkhm, Feb 23, 2010 IP