Additional Tag Column to the Saveas-csv-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
consuli
Posts: 15
Joined: Thu Jan 13, 2011 1:33 pm

Additional Tag Column to the Saveas-csv-File

Post by consuli » Tue Jan 25, 2011 12:39 pm

Hello!

I need an additional tag for further data processing. The read webdata is so scrumbeled with "\n" and other nasty signs, I cannot further process it without a tag for the data row.

How can I write a constant tag as an additional column to the saveas-file?

Thanks
Consuli
Last edited by consuli on Thu Jan 27, 2011 9:04 am, edited 1 time in total.
cboshdave
Posts: 53
Joined: Fri May 16, 2008 6:11 pm

Re: Additional Tag Column to the Saveas-csv-File

Post by cboshdave » Thu Jan 27, 2011 3:53 am

Couldn't you just do a search and replace in a more aggressive text editor at this point? Try Notepad ++ or something like that. Then you can search for \n and replace it with "something"\n.

Just a thought. If that is not what you were looking for, maybe I need more information?

Dave
consuli
Posts: 15
Joined: Thu Jan 13, 2011 1:33 pm

Re: Additional Tag Column to the Saveas-csv-File

Post by consuli » Thu Jan 27, 2011 9:06 am

cboshdave wrote:Couldn't you just do a search and replace in a more aggressive text editor at this point?
Sure. But difficult to automatize.

Consuli
Tom, Tech Support
Posts: 3834
Joined: Mon May 31, 2010 4:59 pm

Re: Additional Tag Column to the Saveas-csv-File

Post by Tom, Tech Support » Thu Jan 27, 2011 5:59 pm

Hi Consuli,

You can add additional values to be saved to your CSV file by using:

ADD !EXTRACT value

Where value is any value you want to save (if the value contains spaces you need to replace them with <SP>).

Each value you add to the extraction buffer, either by using TAG ... EXTRACT=... or using ADD !EXTRACT, will be saved as a separate column in your output file.
Regards,

Tom, iMacros Support
consuli
Posts: 15
Joined: Thu Jan 13, 2011 1:33 pm

Re: Additional Tag Column to the Saveas-csv-File

Post by consuli » Thu Jan 27, 2011 9:09 pm

Thank you Tom. That's exactly what I am looking for.

Consuli
Post Reply