By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


ExtractHTMLData

This routine is passed 2 parameters
  • sSearch - string
  • sType - not

    Currently uses the file in the SharePoint DER directory

    It will create a new file with just the extracted strings.
  • Get input file
  • Get output file name
  • Open input file
  • Create output file
    • Add header to output with the search parameter
    • Loop
    • get input records and store to a string
    • end loop
    • Loop
    • if string in row then add to new
    • Add headers also
    • if not string then skip record only add if not in row
    • Open the page
    • save the files

    Prerequisites
  • Sub - End Sub
  • Parameters
  • Dim
  • String
  • Variables
  • SharePoint
  • Concatenation
  • If else end if
  • On error
  • Stop
  • bOpenSeqFile
  • Print #y
  • HTML
  • Do Loop
  • Line Input #x
  • eof(x)
  • S = s & sInput
  • Intstr
  • Mid
  • Doevents
  • Close
  • Exit do





    • blog comments powered by Disqus