|
|
| Author |
Message |
Goraz
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3736
Location: Philadelphia
|
 Posted: 09/02/05 - 12:19 Post subject: Hepl with finding a certain kind of software
|
|
|
I'm looking to find a good program for my job that is capable of running queries on matching a set of numbers / text.
For instance, since Excel can't do shit, I'll have column A full of unique ID #s and column B full of another set of numbers. I'm trying to filter out if there are any possible matching pairs in Col A & B. Believe me, excel doesn't match them properly and I know all the formulas in excel for comparing variables. Even advanced filter doesn't pick it up.
Now does anyone know a good program that can do this? Especially query it (i.e - I have a list of values I can enter in all at once and perform a search through a spreadsheet to identify matches)
ty.
|
|
|
Back to top
|
|
|
|
 |
sinrakin
RealPoor Master of Posts
Joined: 11 Oct 2002
Posts: 7044
|
|
Posted: 09/02/05 - 12:22 Post subject:
|
|
|
grep? 
|
|
|
Back to top
|
|
|
|
|
kireol
RealPoor Master of Posts
Joined: 02 Aug 2003
Posts: 9517
Location: Royal Oak, MI
|
|
Posted: 09/02/05 - 12:22 Post subject:
|
|
|
SQL can do it easy. like mysql.
but, you'd have to know how to use that.
so ummmm. try MS access(i cant beleive i just said that.)
|
|
|
Back to top
|
|
|
|
|
Occulis
RealPoor Jedi
Joined: 11 Oct 2002
Posts: 13293
Location: Moral Relativity Central
|
|
Posted: 09/02/05 - 12:57 Post subject:
|
|
|
|
MySQL is free and SQL is easy to learn.
|
|
|
Back to top
|
|
|
|
|
Goraz
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3736
Location: Philadelphia
|
|
Posted: 09/02/05 - 17:36 Post subject:
|
|
|
|
i know a little about SQL.... atleast from setting up PHBB 2.0 forums =\
|
|
|
Back to top
|
|
|
|
|
kireol
RealPoor Master of Posts
Joined: 02 Aug 2003
Posts: 9517
Location: Royal Oak, MI
|
|
Posted: 09/02/05 - 17:41 Post subject:
|
|
|
oh. it'd be easy then.
grab and install MYSQL
grab ummm "matts csv to mysql converter" i think it's called. This will make it easy to go from XL to mysql
then just write a query.
phpmyadmin is a nice tool to use too
|
|
|
Back to top
|
|
|
|
|
Goraz
RealPoor Guru
Joined: 11 Oct 2002
Posts: 3736
Location: Philadelphia
|
|
Posted: 09/06/05 - 09:17 Post subject:
|
|
|
| kireol wrote: | SQL can do it easy. like mysql.
but, you'd have to know how to use that.
so ummmm. try MS access(i cant beleive i just said that.) |
my company uses datatrac SQL... so I'm guessing i wouldnt need a converter to dump the data from our network?
|
|
|
Back to top
|
|
|
|
|
kireol
RealPoor Master of Posts
Joined: 02 Aug 2003
Posts: 9517
Location: Royal Oak, MI
|
|
Posted: 09/06/05 - 09:31 Post subject:
|
|
|
|
you'll need some way to get the data in.
|
|
|
Back to top
|
|
|
|
|
mixelplux
Luke Warm
Joined: 23 Nov 2002
Posts: 344
|
|
Posted: 09/06/05 - 11:38 Post subject:
|
|
|
|
Not sure how useful these days, but Perl used to be an incredible text parsing tool. You would have to learn Perl of course. Not sure if setting up a online database just purely for pattern matching is a great idea. If you would like a better database than Excel, then go for it.
|
|
|
Back to top
|
|
|
|
|
Trebel
Luke Warm
Joined: 13 Oct 2002
Posts: 213
|
|
Posted: 09/06/05 - 11:44 Post subject:
|
|
|
|
SPSS v. 13.0
|
|
|
Back to top
|
|
|
|
|
|
|
