save csv data to another csv with blank cells

Discussions and Tech Support related to the iMacros Firefox Add-on, including the built-in Javascript scripting interface for playing .js files.
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.
Post Reply
techimac
Posts: 280
Joined: Fri Feb 20, 2015 9:27 pm

save csv data to another csv with blank cells

Post by techimac » Wed May 09, 2018 6:40 am

Code: Select all

SET !DATASOURCE RealEstate.csv
SET !DATASOURCE_COLUMNS 25
SET !DATASOURCE_LINE {{LOOP}}
SET !EXTRACT {{!COL1}}
ADD !EXTRACT {{!COL3}}
ADD !EXTRACT {{!COL4}}
ADD !EXTRACT {{!COL5}}
ADD !EXTRACT {{!COL6}}
ADD !EXTRACT {{!COL7}}
ADD !EXTRACT {{!COL8}}
SAVEAS TYPE=EXTRACT FOLDER=* FILE=RealEstate-DATA.csv
how to save empty cell?
if cell is empty then data is saved in previous cell in output file
Post Reply