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.
Forum rules
iMacros EOL - Attention!

The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.

Thank you again for your business and support.

Sincerely,
The Progress Team

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
jiri

extract value from txt input file to cvs output file

Post by jiri » Tue Oct 11, 2005 3:21 pm

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.a ... id={{!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
User avatar
Tech Support
Posts: 4948
Joined: Tue Sep 20, 2005 7:25 pm
Contact:

Post by Tech Support » Tue Oct 11, 2005 9:19 pm

Code: Select all

SET !EXTRACTADD {{!COL1}}
is correct. Please make sure that you test with V4.30 or later.
Post Reply