extract value from txt input file to cvs output file

Discussions and Tech Support related to website data extraction, screen scraping and data mining using iMacros.

Moderators: Community Moderators, iMacros Moderators

Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the Google search box (at the top of each forum page) to see if a similar problem or question has already been addressed. This will search the entire contents of the forums as well as the iMacros Wiki.
3. We can respond much faster to your posts if you include the following information:

CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST

Answering your own posts (e.g. attempting to "bump" your topic) drops your topic from the list of unanswered threads, so it may actually receive less views.

extract value from txt input file to cvs output file

by jiri on Tue Oct 11, 2005 8:21 am

i am trying to extract search strings from test input file with id's separated with page break (1100,1101,1102...) into the csv output file (i want to mark extracted entries with their id's. In the macro, i am getting error for following code
CMDLINE !DATASOURCE lake.csv
SET !DATASOURCE_COLUMNS 1
SET !EXTRACT_TEST_POPUP NO
SET !DATASOURCE_LINE {{!LOOP}}
URL GOTO=http://www.worldlakes.org/lakedetails.asp?lakeid={{!COL1}}
SIZE X=883 Y=673
SET {{!EXTRACTADD}} {{!COL1}}
SAVEAS TYPE=EXTRACT

Error:
Error: SET Parameter not recognized: (NOT FOUND: !extractadd)

I also tried
SET !EXTRACTADD {{!COL1}}
and
ADD {{!EXTRACT}} {{!COL1}}
and
ADD !EXTRACT {{!COL1}}
and
ADD {{!COL1}} !EXTRACT

Do you have some running example code. What is exact syntax?
Thanks
Jiri
jiri
 

by Tech Support on Tue Oct 11, 2005 2:19 pm

Code: Select all
SET !EXTRACTADD {{!COL1}}


is correct. Please make sure that you test with V4.30 or later.
User avatar
Tech Support
 
Posts: 5003
Joined: Tue Sep 20, 2005 12:25 pm


Return to Data Extraction and Web Screen Scraping

Who is online

Users browsing this forum: No registered users and 5 guests

-->