• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

calling all programmers

jimi_81

Moderator
Political User
#1
Hi guys. I was wondering if anyone at OSNN is a excel macro wiz, or php, etc.

This is what I have:
Date Time Type Field1 Field2
May 17 6pm practice 3 & 4 1


Id like it to read:
May 17 6pm practice 3 & 4 Field1
May 17 6pm practice 3 & 4 Field2

Any suggestions? Quick and painless? or excessively complicated?

thanks
 

SPeedY_B

I may actually be insane.
#2
Literally like that? Just text separated by spaces? Little more info, or even the file the info is coming from would be handy :)
 

zeke_mo

(value not set)
Staff member
Political User
#4
I tried to write a program one time. It was a .bat file that had this in it, "shutdown -s". I lost several friends over it after putting it in their startup folder. I then tried to sell them the antidote, which was "shutdown -a". That didnt go over very well :(
 
Last edited:
#5
Is this all? or am i missing something in the question?

Just change the format type on the cells to date with the format you want.

Arggh, I see. Set the language on the cell format to English united states, offers more options than canadian.

Or did you want to ditch the - between month and day too?
And did you want it to automatically fill in the playing field name based on something else.

All of the above can be done pretty easily. Let me know.
 

Attachments

Last edited:

jimi_81

Moderator
Political User
#6
no no no
haha
sorry guys.
i have a HUGE list of data. i just posted one row in the excel file.

I need to make a macro to do this, i assume.

It seems logical. Heres how i break it down...
On a particular day there are x amounts of games to be played. And there are x amount of field. i need the data in a format i can easily drop into a database.

---------field1-------field2------field3------field4
gameday match1-----match2----match3----match4
(edit: i dont know how to make a table in a post! sorry!!)


to be read into the db, i need it like:

gameday - match1 field1
gameday - match2 field2
gameday - match3 field3
gameday - match4 field4

so, IF their are 4 matches on 4 fields, then i need to insert X-1 rows. 3 new rows. and then i need the field names to move almost like a transpose.

sorry, i wasnt clear at all.

hope this help
thanks
 
Last edited:

Members online

No members online now.

Latest posts

Latest profile posts

Perris Calderon wrote on Electronic Punk's profile.
Ep, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there https://tinyurl.com/ycpxl
Electronic Punk wrote on Perris Calderon's profile.
All good still mate?
Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,962
Messages
673,240
Members
89,015
Latest member
loxioalix