View Full Version : GRRRRR, stoopid commas!!!
FrogMan
01-08-2004, 10:31 PM
they added commas to the player values and now my Hattrick spreadsheets won't parse the player listing right!!! GRRRRR!!! :mad: :mad: :mad:
if it ain't broke, don't fix it, they say... The match reports are nice now, the commas were not necessary, at least I was never raised to use them here in Quebec... oh well...
FM
finkenst
01-08-2004, 10:34 PM
i just don't see his myself:
Jeffrey Wheatley
171 000 US$, 26 years, passable form
Has weak experience and passable leadership abilities [Quick]
....
uynless it's the commas in the $, 26 yo, passable...
FrogMan
01-08-2004, 10:38 PM
Tim, I read your comment in the USA conference, replying to Brandon. Brandon is in Canada too, I guess this is only in Canada... Look at Nick's value below...
Your 25 players
Nick de Hooge
1,174,000 C$, 23 years, passable form
Has inadequate experience and weak leadership abilities
Stamina: excellent Keeper: excellent
Playmaking: disastrous Passing: wretched
Winger: disastrous Defending: disastrous
Scoring: disastrous Set Pieces: wretched
My parser was looking for the first comma as the delimiter for the value, now I'm gonna make it look for the "C$" and then have to substitute all the "," for "" in order to be able to make a value out of it, a tiny pain, but unneeded...
FM
finkenst
01-08-2004, 10:42 PM
hehehehehehehe...
i just posted the same thing to brandon. :)
Qwikshot
01-08-2004, 11:06 PM
I had commas and I'm in the U.S.
terpkristin
01-08-2004, 11:26 PM
I don't know much about Excel...but my values and stuff worked fine in your killer spreadsheet. Is this possibly related to some of the issues that US people had when you first posted your spreadsheet? I seem to remember there was some problem with the spreadsheet not working for us US players...but I definitely don't remember what the problem was...
~tk
Mr. Wednesday
01-09-2004, 12:25 AM
The original problem with FM's spreadsheet (at least, the one I encountered) was with the VALUE function in older versions of Excel.
I don't have commas and using "English" language in my French League.
FrogMan
01-09-2004, 07:10 AM
Commas have disappeared from my players page this morning, weird...
tk, as Mr. Wednesday said, the problem was with some version of Excel not being able to compute the "value" function with spaces in the middle of a number shown as text...
oh well, for now everything works as before, we'll see if the disappearing commas resurface again...
FM
GRRRRR, stoopid commas!!! - There are commas now in the players page and on the economical page too.... transfert history as well....
finkenst
01-09-2004, 09:14 AM
ARgh!
stoopid commas!!!!
they must be spreading from canada.
wait a minute, wtf?!!?
now there are no commas...
Fonzie
01-09-2004, 09:23 AM
Originally posted by vexroid
I have comas too.
You might want to see a doctor about that.
;)
FrogMan
01-09-2004, 09:40 AM
Originally posted by finkenst
ARgh!
stoopid commas!!!!
they must be spreading from canada.
wait a minute, wtf?!!?
now there are no commas...
yeah, we sent you our commas. Being that they are stoopid, they thought that being closer to Celine Dion was a good thing, MUAHAHAHAHAHAH!!!!! :D
FM
Desnudo
01-09-2004, 10:06 AM
aaaaawww.
All things evil come from Canada.
MacroGuru
01-09-2004, 11:11 AM
Wait, I thought that was North Dakota?
Desnudo
01-09-2004, 11:55 AM
Isn't that a Canadian province?
Hobbes-
01-09-2004, 01:59 PM
Originally posted by indoorsoccersim
Wait, I thought that was North Dakota?
nope.. canada gave us mad cow.. and tried to hide it for 2 years..
Hobbes-
01-09-2004, 02:01 PM
They prolly gave us the Evil SouthPark Cows too.. fckin worthless cows..
PUT EM ALL DOWN! KILL KILL!!
finkenst
01-09-2004, 05:00 PM
back on topic of this thread...
I am starting to suspect it might depend on which server you get... e.g. .158 and no commas. now on .154 and i have commas again.
FrogMan
01-09-2004, 05:05 PM
ouch, this is gonna be a major pain then...
FM
finkenst
01-09-2004, 05:07 PM
yeah
195.149.159.155:
Vicent Ribelles
97 000 US$, 30 years, passable form
Has poor experience and weak leadership abilities
195.149.159.154:
Vicent Ribelles
97,000 US$, 30 years, passable form
Has poor experience and weak leadership abilities
vBulletin v3.6.0, Copyright ©2000-2026, Jelsoft Enterprises Ltd.