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

I Need A Little Help Guys About iMacros. How To Save This TEXT into .CSV 3 Column?

Discussion in 'General Scripting Chat' started by purewealthinc, Aug 3, 2014.

  1. purewealthinc

    purewealthinc Regular Member

    Joined:
    May 3, 2010
    Messages:
    427
    Likes Received:
    383
    Occupation:
    Web Fishing
    Location:
    World Wide Web City
    I Need A Little Help Guys About iMacros.

    How To Save This extracted TEXT into .CSV 3 Column? I want to save this extracted text into Excel or .CSV file like this

    Col1 Col2 Col3
    Fullaname Address Country


    Code:
    VERSION BUILD=8032216TAB T=1
    TAB CLOSEALLOTHERS
    SET !ERRORIGNORE YES
    '
    URL GOTO=http://blog.nathanbransford.com/2011/05/how-to-use-twitter-reply.html
    TAG POS=1 TYPE=DIV ATTR=TXT:Nathan<SP>Bransford<SP>Brooklyn,<SP>NY<SP>United<SP>States
    '
    SAVEAS TYPE=EXTRACT FOLDER=D:\Marketing FILE=Extract_{{!NOW:8-2014}}.csv

    Please help me guys.. Check the iMacros code above.
     
  2. Creative9

    Creative9 Junior Member

    Joined:
    May 22, 2014
    Messages:
    136
    Likes Received:
    15
    I think this may work.
    Just put comma within the macro, after you extracted the data and open the file, I think the comma should seperate them into another column, if it doesn't just put in notepad and save as .csv file and open again. You can also just put for example a $ sign instead of comma, then search/replace into comma later on.
     
  3. purewealthinc

    purewealthinc Regular Member

    Joined:
    May 3, 2010
    Messages:
    427
    Likes Received:
    383
    Occupation:
    Web Fishing
    Location:
    World Wide Web City
    Thank's mate.. I tried it bu I can't figured it out..

    I tried this but when extracted the data, It only saves into 1 column.. Can someone share your info with this?

    Code:
    VERSION BUILD=8032216TAB T=1TAB CLOSEALLOTHERS
    SET !ERRORIGNORE YES
    '
    URL GOTO=http://blog.nathanbransford.com/2011/05/how-to-use-twitter-reply.html
    '
    TAG POS=1 TYPE=DIV ATTR=TXT:Nathan<SP>Bransford<SP>Brooklyn,<SP>NY<SP>United<SP>States
    '
    TAG POS=1 TYPE=DIV ATTR=TXT:* EXTRACT=TXT
    '
    SAVEAS TYPE=EXTRACT FOLDER=D:\Marketing FILE=Extract_{{!NOW:8-2014}}.csv
    Need lil help from our iMacros expert here in BHW.
     
  4. Creative9

    Creative9 Junior Member

    Joined:
    May 22, 2014
    Messages:
    136
    Likes Received:
    15
    Use exactly this line instead in your imacro -
    TAG POS=1 TYPE=DIV ATTR=TXT:Nathan<SP>Bransford$$Brooklyn&&<SP>NY$$United<SP>States

    Now, after you extract the data. You will get them in 1 column, copy the data and put into notepad, then search/replace $$ into comma. And then save the file as a.csv, now when you open the csv file, you will get them in 3 columns. And then you can search replace && into comma once again later.

    Follow instruction exactly, it should work.
     
  5. purewealthinc

    purewealthinc Regular Member

    Joined:
    May 3, 2010
    Messages:
    427
    Likes Received:
    383
    Occupation:
    Web Fishing
    Location:
    World Wide Web City
    Thanks bro.. but i got this error

    Error -1100: Wrong format of TAG POS=1 TYPE=DIV ATTR=TXT:Nathan<SP>Bransford$$Brooklyn&&<SP>NY$$Un ited<SP>States command, at line: 7
     
  6. Creative9

    Creative9 Junior Member

    Joined:
    May 22, 2014
    Messages:
    136
    Likes Received:
    15
    Could be that there is space in the - Un ited. Remove the space.