How do i Extract data Separated by <br>

Discussions and Tech Support related to website data extraction, screen scraping and data mining using iMacros.
Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
nveeravalli
Posts: 19
Joined: Thu Apr 01, 2010 11:25 am

How do i Extract data Separated by <br>

Post by nveeravalli » Tue Apr 13, 2010 6:55 am

Multiple items inside one cell are separated by <br> instead of creating individual cells for the data. How do I extract data separated with <br>

IRS JACKSONVILLE
P.O. BOX 35045
STOP 5750 ATTN: LIEN CLERK
JACKSONVILLE, FL 322020045 US
FEI/EIN Number: NONE

I am using Extract wizard but unable to retrieve the required information, please suggest me VB scriptCode / Macro code.
slamsal
Posts: 96
Joined: Fri Sep 12, 2008 4:39 pm

Re: How do i Extract data Separated by <br>

Post by slamsal » Tue Apr 13, 2010 3:17 pm

VBS Function

Code: Select all

Dim iret, iim1, extract, newextract

Set iim1 = CreateObject("imacros")
iret = iim1.iimInit
iret = iim1.iimPlay("testmacrowithextract")
extract = iim1.iimGetLastExtract(1)
newextract = Split(extract , Chr(13))

Msgbox newextract (0)
Msgbox newextract (1)
Msgbox newextract (2)
This should give you an idea. Keyword is: iim1.iimGetLastExtract(1), Split and Chr(13).

I am making a web application/services that will make data extraction and scraping lot easier with almost no coding at all. I will post more details about it soon.
Sanjiv Lamsal
iMacros Consultant
Duluth, MN USA
sanjivlamsal@hotmail.com
Daniel, Tech Support
Posts: 1483
Joined: Tue Jan 26, 2010 11:35 am

Re: How do i Extract data Separated by <br>

Post by Daniel, Tech Support » Wed Apr 14, 2010 4:50 pm

Thanks Sanjiv!
Daniel, iOpus Support
nveeravalli
Posts: 19
Joined: Thu Apr 01, 2010 11:25 am

Re: How do i Extract data Separated by <br>

Post by nveeravalli » Wed Apr 14, 2010 8:43 pm

Thanks Sanjiv,

I really appreciate for your help on this, i sorted out the problem with this hint. Please keep me posted with your new software.

Naveen
nveeravalli@gmail.com
Post Reply