Search found 10 matches

by Marlon
Tue Dec 15, 2009 2:52 am
Forum: Data Extraction and Web Screen Scraping
Topic: Merge Multiple Csv Files
Replies: 1
Views: 713

Merge Multiple Csv Files

I have situation where I am sure many have encountered and I'd like to share a solution. I have a macro that scrapes data from a page and data is downloaded to a csv file for each set of data. I needed to download a total of 3000+ csv files. My problem was - how do I merge these files into one file ...
by Marlon
Wed Mar 18, 2009 3:38 pm
Forum: How-To's and Examples for Form Filling
Topic: CSV Standard File Format
Replies: 11
Views: 103368

Re: CSV Standard File Format

I am having the same problem with entries in my csv file. For example, in a specific spreadsheet cell, I have the string: cats and "hot dogs". What modifications do I do to the actual spreadsheet cell? When doing the form-filling with a CONTENT={{!COL3}}, I get "cats and" as the value. I've tried (s...
by Marlon
Wed Mar 04, 2009 7:11 pm
Forum: General Support & Discussions
Topic: Commenting out Multiple Lines in a Macro
Replies: 1
Views: 3297

Commenting out Multiple Lines in a Macro

The character used for adding comments on each line in a macro is ' . How can I comment out multiple lines at once, where I don't have to add the ' on each line? Please advise. In most programming languages, there is provision for this such as: /* or <!-- etc.
by Marlon
Thu Feb 26, 2009 5:06 am
Forum: General Support & Discussions
Topic: finding and replacing or deleting text and image lins
Replies: 2
Views: 1041

Re: finding and replacing or deleting text and image lins

Very good question - Tech Support has been dodging these questions. Is the program capable of deleting and adding new text?
by Marlon
Thu Feb 26, 2009 5:00 am
Forum: General Support & Discussions
Topic: Editing posts with iMacro
Replies: 4
Views: 1065

Re: Editing posts with iMacro

Tech Support and Elep,

How would one go about doing this? I am wordpress posts and I have the same issue. Please advise the forum a possible workflow for this.
by Marlon
Mon Feb 16, 2009 9:00 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Loop and Save to Same File
Replies: 3
Views: 1837

Re: Loop and Save to Same File

Marcia, I've tried your code but extracted data is saving in column 2 of the output file. That is fine but not what I'm after. If I do this, I would have to make a copy of my input file leaving column 2 empty for the extract data. Isn't there a way to just insert extracted data into the input source...
by Marlon
Sun Feb 15, 2009 8:52 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Loop and Save to Same File
Replies: 3
Views: 1837

Loop and Save to Same File

Hello, I just purchased the Pro Edition. Great stuff. I have a very common scenario and hopefully, there is a simple and trivial solution. I have a CSV file with 2 columns. I need to LOOP through 20 rows of column 1 and EXTRACT the resulting data from each query and save the extracted data into colu...
by Marlon
Tue Dec 11, 2007 1:52 pm
Forum: General Support & Discussions
Topic: CSV file and problem with form filling
Replies: 2
Views: 1081

I am not sure of your question, please reiterate.
by Marlon
Wed Dec 05, 2007 8:01 pm
Forum: General Support & Discussions
Topic: CSV file and problem with form filling
Replies: 2
Views: 1081

CSV file and problem with form filling

Mac OS: 10.4 Firefox: 2.0.0.11 iMacros Add-on: 6.0.1.3 I have a CSV file with one column, which contains 30 rows of numeric data. Code: VERSION BUILD=6011123 RECORDER=FX TAB T=1 URL GOTO=http://www.whateverwebsite.com SET !DATASOURCE test.csv SET !DATASOURCE_COLUMNS 1 SET !DATASOURCE_LINE {{!LOOP}} ...
by Marlon
Tue Nov 20, 2007 8:42 pm
Forum: Data Extraction and Web Screen Scraping
Topic: Multiple Fill, extract and Save to One File
Replies: 2
Views: 1937

Multiple Fill, extract and Save to One File

My objective is to fill out an online form, extract the resulting table and write to a single CSV file. The problem: I have to enter numbers 1-4000 in one of the form cells. Should each number come from an uploaded CSV file (where there is a column of 4000 numbers) or is there code to handle this re...