Picking data from a web field, splitting it into two values

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
ZeitenWanderer
Pro Scripter
Posts: 68
Joined: Wed Dec 07, 2005 7:13 am

Picking data from a web field, splitting it into two values

Post by ZeitenWanderer » Tue Mar 31, 2015 7:08 pm

Wanted to pick data from a website comparing prices - this may be quick or dead slow.

Code: Select all

  // Extract pricing and forum of top result
  // Used the IE Element Wizard to extract data here   
  IEGetTagsByAttrib>{"http://www.recyclingmonster.de/verkaufen/buecher"},SPAN,,T,valueArray

      //top result is valuearray_1
      Let>offer=valueArray_1
 
      //format is: forum 1,00€
      // (first is forum, second price)
      Separate>forum,price_parts,€
      Let>main_price=price_parts_1

      //update price in database
      Let>SQL=UPDATE tblBuchdaten SET ankaufname='%main_price%' WHERE ArticleID='%article_id%';
      DBExec>dbH,SQL,dbRes
But all I receive is "price_parts_1" - thus I checked the site again and realised they first of all show a "wait for results", before they display the desired data. Thus I want to put in a command to move on after ""wait for results" is no longer present.
How to? :-)

User avatar
Marcus Tettmar
Site Admin
Posts: 7395
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Re: Picking data from a web field, splitting it into two val

Post by Marcus Tettmar » Thu Apr 02, 2015 2:58 pm

You might be able to use IEWaitForText or WaitScreenImage or something like that to wait for something which only appears when the results have appeared.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts