html - VBA finding the last instance of a phrase before a different key phrase? -

html - VBA finding the last instance of a phrase before a different key phrase? -

August 15, 2010

I have a large string that comes from the HTML source code (about 1,000,000 characters long). I am using msinet.ocx to see text from proper websites. I have written a small section of code to search for an important phrase ("pcad ="), which is just before a different key phrase ("component accessory matrix"), but it is not working properly. Here I am now:

  workspace = cells (columnNumber, 1) .Value myURL = "http://beams.us.yazaki.com/Beams/ViewDetails.aspx?topic = Document & amp; pkid = "_ & amp; Vertical inet1 dim cabinet dim MyPage string set inet1 = inet1 with as the new Cabinet .Protocol = icHTTP .url = myURL MyPage = CAMnum with .OpenURL (.url, icString) = InStr end (MyPage, "Component accessory matrix ") intStart = InStrRev (MyPage," pkid = ", CAMnum) + 5 newnum = Middle (MyPage, intStart, 6) cells (columnNumber, 2) .Value = newnum    The problem is with  mypage =. Open URL (.URL, icString) ; When I run  len (mypage) , it gives value of approximately 100,000, when it should return the value of approximately one million  InStr  and  InStrRev    
 
 Code>, find your string, look back. Once you have this situation, look forward to as long as we do not search quote characters. Finally, use those conditions to get the string    pos1 = InStrRev (your XML string, "pcad =", inset (your XML string, "component accessory matrix")) + 5 'Length' pkid = "Note that if      " component accessory matrix " is unavailable, or before < Em> is not "pkid =" , or is not a bid delimiter, or more  pkid =  and quotation marks, the code will fail and / or generate nonsense results.   

 


  

















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




apache - How to do an URL rewrite that works with a
pre-existing .htaccess file? -



    I have a platform that is currently available through the URL:    Www.websitecom / index.php? App = forum    Instead, I want people to be able to go here:      & lt; Ifmodule mod_rewrite.c & gt; Option - Multi Views RewriteEngine RewriteBase / RewriteCond on% {REQUEST_FILENAME}! -f Rewrite Convert% {REQUEST_FILENAME}! -d rewriteable /index.php [L] & lt; / IfModule & gt;    It seems that it should be possible, but I'm not sure how to do it.   Thank you!      This has not been tested, but something like that should be done. Add it before the first Rev.Directivity.    RewriteRule ^ forum $ /index.php?app=forums    Alternatively, you redirect from a 301 / forum to index.php URL .   By doing this:    301 / redirect the forum "http://www.website.com/index.php?app = forum    However, it seems that you want to make a proper rewrite, so the first option is better,     






c# - EventSource's response has a MIME type ("text/html") that is
not "text/event-stream" -



    When I try to hook my controller to EventSource, it keeps saying:    EventSource Response contains a MIME type ("text / html") that is not "text / event-stream" canceling connection.    I have created the following class to help in handling a handle and preparing the reaction. In this class I believe that I set the  text / event-stream  according to the response.    public class ServerSentEventResult: ActionResult {public representative string GetContent (); Public GetContent Content {get; Set; } Public int version {get; Set; } Public Override Zero ExecuteResult (Controller Context Reference) {if (context == null) {New argument NullException ("Reference"); } If (this. Content! = Null) {HTPRPPointbase response = reference. Hpptntx response; reaction. Contact type = "text / event-stream"; reaction. BufferOutput = false; reaction. Chargset = Faucet; String [] newStrings = context.HttpContext.Request.Headers.GetValues ("last-event-id"...






android - How to build apk without eclipse or Modify the apk building
with a config file? -



    I want to create an APK with some big configurations with an XML file.  I want to know if there is any method which can control the APK's building process or encoding at our source, there is no way to create APK with our source from our source, with a slight variation based on our SQF XML file. . Or any other way to create an APK file    When the app is running, I do not want to read my config file every time, I have to include a change in the application        If you want to manually create your application:    If you are developing in Eclipse, then the ADT plugin The enhanced project as you make changes to the source code. Eclipse automatically produces an .apk file in the project's bin folder, so you do not need to do anything extra to generate .apk.   If you are developing in a non-eclipse environment, then you create your project with the Generated Build.xml Ant file in the project directory that creates ant file calls which automatically targets you for Call the buil...








Powered by Blogger