csv files

Discussion in 'Mac Apps and Mac App Store' started by hjalte, Jan 15, 2015.

  1. hjalte macrumors member

    Joined:
    Dec 23, 2014
    #1
    This is a long shot, I know, but maybe you guys know of a piece of software that can help me.

    I need a way to extract columns (only some) from a csv file and then put them into a new csv file in the correct order.

    FInally, I need to do some kind of a lookup from another table.

    Before you say excel or calc + a macro, i have had a real hard time getting it to work.

    I can do it easily on my PC, but on mac it simply doesn't work.

    I know there are programs like filemaker and I thought that maybe, there was an easy solution to my problem.

    The thing is that I get a csv file with orders each and every day and I need to format that correctly (basically deleting some columns and adding the price from another spreadsheet).

    Any ideas?
     
  2. maflynn Moderator

    maflynn

    Staff Member

    Joined:
    May 3, 2009
    Location:
    Boston
    #2
    I do hate to say it, but I would say excel may be your best option.

    Take a look at ultraedit I use that on windows, and I've used it on OSX. There's a way to select a column of data, so that may be helpful
     
  3. hjalte thread starter macrumors member

    Joined:
    Dec 23, 2014
    #3
    Yeah, maybe you are right.
    I really liked the idea of using openoffice though.

    Maybe I should just figure out why the macro don't work instead :)
     

Share This Page