1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

iMacro help?

Discussion in 'Social Networking Sites' started by Hiapplz, May 5, 2013.

  1. Hiapplz

    Hiapplz Junior Member

    Joined:
    Apr 2, 2013
    Messages:
    140
    Likes Received:
    13
    (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!
     
  2. DopeyDuke

    DopeyDuke Junior Member

    Joined:
    Apr 18, 2013
    Messages:
    107
    Likes Received:
    17
    Location:
    PI
    Home Page:
    This is pretty basic programming. Give an example and I can program one for you in a few minutes.
     
  3. Hiapplz

    Hiapplz Junior Member

    Joined:
    Apr 2, 2013
    Messages:
    140
    Likes Received:
    13
    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
     
  4. DopeyDuke

    DopeyDuke Junior Member

    Joined:
    Apr 18, 2013
    Messages:
    107
    Likes Received:
    17
    Location:
    PI
    Home Page:
    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?
     
  5. Hiapplz

    Hiapplz Junior Member

    Joined:
    Apr 2, 2013
    Messages:
    140
    Likes Received:
    13
    yes sir!
     
  6. DopeyDuke

    DopeyDuke Junior Member

    Joined:
    Apr 18, 2013
    Messages:
    107
    Likes Received:
    17
    Location:
    PI
    Home Page:
    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.
     
    • Thanks Thanks x 1
  7. Hiapplz

    Hiapplz Junior Member

    Joined:
    Apr 2, 2013
    Messages:
    140
    Likes Received:
    13
    Okay thank you!
     
  8. Hiapplz

    Hiapplz Junior Member

    Joined:
    Apr 2, 2013
    Messages:
    140
    Likes Received:
    13
    Bump?
     
  9. Hiapplz

    Hiapplz Junior Member

    Joined:
    Apr 2, 2013
    Messages:
    140
    Likes Received:
    13
    I don't think anyone else will be helping :/
     
  10. Hiapplz

    Hiapplz Junior Member

    Joined:
    Apr 2, 2013
    Messages:
    140
    Likes Received:
    13
    How so? I have like 60 files i cant do it one by one
     
  11. Gshatter

    Gshatter Newbie

    Joined:
    May 8, 2013
    Messages:
    3
    Likes Received:
    0
    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.