Data Manipulation programs.

chris-red · Have you considered a TDM? Joined: 21 Sep 2005 Karma :

Can anyone suggest some good Programs.

Ideally I'd like something like Excel but without it being 'clever' and automatically 'correcting' things.

i.e

Removing leading 0's or thinking because a number has an 'E' in it is a scientific notation.

I know there are ways around this but it becomes infuriating after a while.

I'm after something that I can import and manipulate different formats of data, Tagged, CSV, Fixed width, Delimited. #

Cheers,
Chris
____________________
Well, you know what they say. If you want to save the world, you have to push a few old ladies down the stairs.
Skudd:- Perhaps she just thinks you are a window licker and is being nice just in case she becomes another Jill Dando.
WANTED:- Fujinon (Fuji) M42 (Screw on) lenses, let me know if you have anything.

el_oso · World Chat Champion Joined: 17 May 2008 Karma :

turn off autoformat in the options?

There's loads of others, depends what type of manipulation you need to do.

If you want to do graphics and other on the fly summaries there's things like Tableau.

You can always use stuff like SQL Server reporting services to do analysis.

There's even more code type things such as r and matlab/octave that will provide you with lots of specific analysis techniques in libraries.

Depends on what you want to do.
____________________
Duke 390
Previous: '05 XR125L | '96 XJ600S Diversion |'05 Suzuki GSXR1000 | '05 Honda CBR125-R | '97 YZF 600R Thundercat | '11 Honda CBR250
Car: Jeep Wrangler 4.0L

The Shaggy D.A. · Super Spammer Joined: 12 Sep 2008 Karma :

linuxyeti · World Chat Champion Joined: 06 Oct 2006 Karma :

Why not try LibreOffice. You can import & export to a variety of formats, and connect to a variety of data sources.

Also it's free, so, nothing to lose by trying it.

If you're used to using MS Office, then it'll be a pretty straight forward shift over to LibreOffice.

I've been using it since the days it was known as Star Office.
____________________
Beware what photos you upload, or link to on here, especially if you have family members on them

chris-red · Have you considered a TDM? Joined: 21 Sep 2005 Karma :

Only simple Manipulations, spiting a file moving bits about find and replace re-formats, compares etc.

I have already turned auto format it still does things.

I had already looked at tableaux however its a grand a licence Rolling Eyes

Will give libre office a go. Thumbs Up

____________________
Well, you know what they say. If you want to save the world, you have to push a few old ladies down the stairs.
Skudd:- Perhaps she just thinks you are a window licker and is being nice just in case she becomes another Jill Dando.
WANTED:- Fujinon (Fuji) M42 (Screw on) lenses, let me know if you have anything.