Welcome, Guest. Please Login or Register.
IRobotSoft Robot
09/05/10 at 13:28:47
News: IRobotSoft is the Best Visual Web Computing Platform!
Home Help Search Login Register


Pages: 1
Send Topic Print
post-process scrape ? (Read 176 times)
bubba
IRobotSoft Newbies
*


I Love IRobotSoft

Posts: 8
post-process scrape ?
02/26/10 at 12:21:54
 
Hi,
 
I have a website that contains an address as one HTML element <tr><td>street town, state zip</td>
 
Is there a way to get each adress element into a different record in irobot ?  
 
receive a csv like this:
street; town; state; zip
 
cheers
bubba
Back to top
 
 
  IP Logged
IRobotSoft Administrator
IRobotSoft Administrator
*****


IRobotSoft, the Best
Internet Robot
System

Posts: 525
Gender: male
Re: post-process scrape ?
Reply #1 - 02/26/10 at 14:05:33
 
You may use htql() function to separate them.  For example, if your HTML element is in a variable a, then use:
htql(a, '<td>:tx. /'',''/1 ./'' ''/1 ') to extract street;
htql(a, '<td>:tx. /'',''/1 ./'' ''/2 ') to extract town;
htql(a, '<td>:tx. /'',''/2 ./'' ''/1 ') to extract state;
htql(a, '<td>:tx. /'',''/2 ./'' ''/2 ') to extract zip.
 
Note that all the '' are two single quots.
Back to top
 
 

The Administrator.
WWW   IP Logged
bubba
IRobotSoft Newbies
*


I Love IRobotSoft

Posts: 8
Re: post-process scrape ?
Reply #2 - 02/27/10 at 02:23:40
 
thank you, this software is amazing !
but where do I find htql () function ?
Back to top
 
 
  IP Logged
IRobotSoft Administrator
IRobotSoft Administrator
*****


IRobotSoft, the Best
Internet Robot
System

Posts: 525
Gender: male
Re: post-process scrape ?
Reply #3 - 02/27/10 at 08:42:43
 
The function is listed in the "Internal Functions: String Functions" section of the iRobot System Advanced Users' Guide.  
 
The detailed syntax of HTQL is in the "The Hyper-Text Query Language (HTQL) – A Web Programmer’s Guide" available at http://htql.net/.
 
Back to top
 
 

The Administrator.
WWW   IP Logged
Pages: 1
Send Topic Print