MESSAGE
| DATE | 2003-04-08 |
| FROM | rc
|
| SUBJECT | Re: [hangout] perl script
|
Joe,
I can't thank you enough. Lunch or beers are on me next time we meet up.
I did not recieve an attachment on this email. Is it on the server
somewhere? That is fine if so, just tell me where.
Thanks again!
~Ray
On Tuesday 08 April 2003 10:17 pm, Joe Villari wrote:
> Here ya go.
>
> It's a tab delimited file.
>
> You had a little over 16,000 original rows of data that changed into
> 970 unique ids.
>
> Don't worry about $$$, it was a good learning experience.
>
> Joe
>
> rc wrote:
> > thanks so much Joe.
> >
> > pls let me know what i owe you
> >
> > thanks again,
> > Ray
> >
> > On Tuesday 08 April 2003 09:15 pm, Joe Villari wrote:
> >>Hey Ray
> >>
> >>I've got it done. Just trying to get the data out of mysql into a
> >>file for ya.
> >>
> >>Joe
> >>
> >>rc wrote:
> >>>Hi Joe,
> >>>Sorry on the delayed reply. I was at the board meeting late and
> >>> the fscc early.
> >>>Yes you can total the number of shares.
> >>>
> >>>Would it be at all possible to complet this by the morning? I will
> >>>pay you for your time and effort. I can offer you $15 an hour for
> >>>it. Let me know what you think.
> >>>
> >>>I really appreciate your help with this Joe. Thanks again.
> >>>
> >>>~Ray
> >>>
> >>> On Monday 07 April 2003 06:42 pm, Joe Villari wrote:
> >>>>Ray
> >>>>
> >>>>Some of these files show differnt share amounts for the same
> >>>>quarter. For example:
> >>>>
> >>>>id 140 has 4 different values for 31-Mar-00 (I've only loaded 9
> >>>>files at this point and checked).
> >>>>
> >>>>mysql> select * from ray where id like '140' and date like
> >>>>'31-Mar-00';
> >>>>+------+---------------------------+-----------+--------+
> >>>>
> >>>>| id | name | date | shares |
> >>>>
> >>>>+------+---------------------------+-----------+--------+
> >>>>
> >>>>| 140 | AIM MANAGEMENT GROUP,INC. | 31-Mar-00 | 30500 |
> >>>>| 140 | AIM MANAGEMENT GROUP,INC. | 31-Mar-00 | 30000 |
> >>>>| 140 | AIM MANAGEMENT GROUP,INC. | 31-Mar-00 | 104600 |
> >>>>| 140 | AIM MANAGEMENT GROUP,INC. | 31-Mar-00 | 309000 |
> >>>>
> >>>>+------+---------------------------+-----------+--------+
> >>>>
> >>>>Is this correct? If so, in the new table do you want the toatl
> >>>>number of shares on 31-Mar-00?
> >>>>
> >>>>It's going fast and smooth using mysql especially with all this
> >>>>data.
> >>>>
> >>>>Joe
> >>>>
> >>>>rc wrote:
> >>>>>Yes Joe, that would be fine.
> >>>>>Thanks Again.
> >>>>>~Ray
> >>>>>
> >>>>>On Monday 07 April 2003 01:57 pm, Joe Villari wrote:
> >>>>>>Ray
> >>>>>>
> >>>>>>Is it possible to have the original input data as a tab
> >>>>>> delimited file? Excel supports this. The problem is there are
> >>>>>> commas used with in the names of some funds which causes the
> >>>>>> splitting to be a bit problematic.
> >>>>>>
> >>>>>>>>>140,"AIM MANAGEMENT GROUP,INC.",30-Jun-00,7600
> >>>>>>>>>2200,"AMERICAN FUND ADVISORS, INC.",30-Jun-00,5150
> >>>>>>
> >>>>>>Joe
--
The Microsoft Crackpipe - Everyone uses it, what harm could it be?
--
Geek Code v3.12
GB/MC/MU/PA d- s+:+ a C++ L+++ P E- W+++ N++ o? K? w+ O? M? V? PS+ PE+
Y+ PGP t+ 5 X R- tv++ b++ DI D G e++ h-- r++ y+
--
____________________________
NYLXS: New Yorker Free Software Users Scene
Fair Use -
because it's either fair use or useless....
NYLXS is a trademark of NYLXS, Inc
|
|
