iMacro help?

Hiapplz

Regular Member

Apr 2, 2013

216

35

• May 5, 2013

• #1

(First of all sorry if this is in the wrong forum but it will be used on a social networking site so...)

Okay, So I was wondering in iMacro is there a way to delete an item of a csv, like say I type in a keyword, It goes through multiple csv's in multiple files and deletes the keywords, (my next step is to copy the non-deleted words/phrases back over to a new csv so if you have input on that, feel free)

+rep and thanks to everyone who helps obviously!
Thanks!

 

DopeyDuke

Junior Member

Apr 18, 2013

107

17

• May 5, 2013

• #2

This is pretty basic programming. Give an example and I can program one for you in a few minutes.

 

Hiapplz

Regular Member

Apr 2, 2013

216

35

• May 5, 2013
• Thread Starter Thread Starter

• #3

DopeyDuke said:

This is pretty basic programming. Give an example and I can program one for you in a few minutes.

Click to expand...

Okay well say I want the word "Killer" removed from
C:\Users\*name*\Documents\iMacros\Datasources\Winning.csv
C:\Users\*name*\Videos\DayZ\huh.csv
and
C:\Users\*name*\Music\5enses - 5TAPE.zip\music.csv
then I want it to copy csv number one (winning.csv) into column one of a new csv with the original file name at the top
C:\Users\*name*\Documents\iMacros\Datasources\Final.csv
then column two would be the 2nd csv and then 3rd into column 3

 

DopeyDuke

Junior Member

Apr 18, 2013

107

17

• May 5, 2013

• #4

I'm sorry it's a little confusing.

So the original csv's only have one column and the final csv will have 3 columns?

 

Hiapplz

Regular Member

Apr 2, 2013

216

35

• May 5, 2013
• Thread Starter Thread Starter

• #5

DopeyDuke said:

I'm sorry it's a little confusing.

So the original csv's only have one column and the final csv will have 3 columns?

Click to expand...

yes sir!

 

DopeyDuke

Junior Member

Apr 18, 2013

107

17

• May 5, 2013

• #6

Alright, Im just a little busy at the moment but I'll check in a few hours and if no solutions has been found by then, I'll compile you a parser.

 

Hiapplz

Regular Member

Apr 2, 2013

216

35

• May 5, 2013
• Thread Starter Thread Starter

• #7

DopeyDuke said:

Alright, Im just a little busy at the moment but I'll check in a few hours and if no solutions has been found by then, I'll compile you a parser.

Click to expand...

Okay thank you!

 

Hiapplz

Regular Member

Apr 2, 2013

216

35

• May 5, 2013
• Thread Starter Thread Starter

• #8

Bump?

 

Hiapplz

Regular Member

Apr 2, 2013

216

35

• May 5, 2013
• Thread Starter Thread Starter

• #9

DopeyDuke said:

Alright, Im just a little busy at the moment but I'll check in a few hours and if no solutions has been found by then, I'll compile you a parser.

Click to expand...

I don't think anyone else will be helping :/

 

Hiapplz

Regular Member

Apr 2, 2013

216

35

• May 6, 2013
• Thread Starter Thread Starter

• #10

How so? I have like 60 files i cant do it one by one

 

G

Gshatter

Newbie

May 8, 2013

3

0

• May 8, 2013

• #11

Vba might be the best way to accomplish this task. Send me your macro code, iMacros version number plus which browser you use (ff,ie,scripting Ed.) to run imacros. Sample csv files and how you determine which keyword is to be removed. I'm no guru, but I've done enough of these projects to realize 1) always take longer than you think 2) hack it together today ... Broke tomorrow.