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 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
techimac
Posts: 292
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