csv files

[hjalte]

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?

 

[maflynn]

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

 

[hjalte]

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

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