ForumCo Support Forums
ForumCo Support Forums
Home | Profile | Register | Active Topics | Active Polls | Members | Private Messages | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ForumCo Support Boards
 Free Forum Support
 two columns of text		  New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 3

Admin
ForumCo Administrator



Éire
4087 Posts
Posted - 09/03/2005 :  07:56:43  Show Profile  Visit Admin's Homepage  Send Admin an ICQ Message  Send Admin a Yahoo! Message Send Admin a Private Message  Reply with Quote
It won't change. If I restrict its use in any way Excel won't be able to access it.
Padraic,

ForumCo Support
www.forumco.com

Helpdesk Knowledgebase Rate ForumCo @ Hotscripts Rate ForumCo @ Cgi-Resources
Please provide:
* error messages * direct link to your forum * any possibly helpful information.
Go to Top of Page

Rambigsky
New Member



53 Posts
Posted - 09/03/2005 :  07:58:55  Show Profile Send Rambigsky a Private Message  Reply with Quote
Padraic,
Now that I took a closer look at the data I notice there is a comma in ever field even if there is no data. This leads me to believe you have city and state information separated. If my assumption is correct please put a delimiter between city and state. That will make my data translation a lot easer.
Go to Top of Page

Admin
ForumCo Administrator



Éire
4087 Posts
Posted - 09/03/2005 :  08:49:18  Show Profile  Visit Admin's Homepage  Send Admin an ICQ Message  Send Admin a Yahoo! Message Send Admin a Private Message  Reply with Quote
There are two columns in the database one for city and one for state. Sometimes the city one is blank or just a space but I will include it anyway as a separate column.

It should now have a delimiter between city and state. If either of these columns are blank the delimiter should still be there so it should keep the correct data in the correct column in Excel.
Padraic,

ForumCo Support
www.forumco.com

Helpdesk Knowledgebase Rate ForumCo @ Hotscripts Rate ForumCo @ Cgi-Resources
Please provide:
* error messages * direct link to your forum * any possibly helpful information.
Go to Top of Page

Rambigsky
New Member



53 Posts
Posted - 09/03/2005 :  23:25:50  Show Profile Send Rambigsky a Private Message  Reply with Quote
Padraic,
Thanks, it now seems to be in a good format for me to work our "displays". Really appreciate your help. Sorry I was not on the ball to start with.
RBS
Go to Top of Page

Admin
ForumCo Administrator



Éire
4087 Posts
Posted - 09/04/2005 :  07:28:40  Show Profile  Visit Admin's Homepage  Send Admin an ICQ Message  Send Admin a Yahoo! Message Send Admin a Private Message  Reply with Quote
No problem.
Padraic,

ForumCo Support
www.forumco.com

Helpdesk Knowledgebase Rate ForumCo @ Hotscripts Rate ForumCo @ Cgi-Resources
Please provide:
* error messages * direct link to your forum * any possibly helpful information.
Go to Top of Page

Rambigsky
New Member



53 Posts
Posted - 11/01/2005 :  02:05:59  Show Profile Send Rambigsky a Private Message  Reply with Quote
Padraic,
You did a great job helping me get the information. Now I find I could use the Country field as well.
The current break out is userID\number\city\state\date joined\posts found on this url
You must be logged in to see this link.
Would you please add country as follows:
userID\number\city\state\country\date joined\posts and use this url
You must be logged in to see this link.
Note: I use the "back slash" as the delimiter.
I ask for a new URL because I have users using my current software and the change would mess it up. Once I get the new software written, tested and in use I will advise you to drop one of the address.

Appreciate all your help.
RBS
Go to Top of Page

Admin
ForumCo Administrator



Éire
4087 Posts
Posted - 11/01/2005 :  04:02:28  Show Profile  Visit Admin's Homepage  Send Admin an ICQ Message  Send Admin a Yahoo! Message Send Admin a Private Message  Reply with Quote
Shouldn't be a problem. I'll look at it this evening and get back to you.
Padraic,

ForumCo Support
www.forumco.com

Helpdesk Knowledgebase Rate ForumCo @ Hotscripts Rate ForumCo @ Cgi-Resources
Please provide:
* error messages * direct link to your forum * any possibly helpful information.
Go to Top of Page

Admin
ForumCo Administrator



Éire
4087 Posts
Posted - 11/01/2005 :  11:52:58  Show Profile  Visit Admin's Homepage  Send Admin an ICQ Message  Send Admin a Yahoo! Message Send Admin a Private Message  Reply with Quote
Done. Any problems let me know.
Padraic,

ForumCo Support
www.forumco.com

Helpdesk Knowledgebase Rate ForumCo @ Hotscripts Rate ForumCo @ Cgi-Resources
Please provide:
* error messages * direct link to your forum * any possibly helpful information.
Go to Top of Page

Rambigsky
New Member



53 Posts
Posted - 11/02/2005 :  03:48:05  Show Profile Send Rambigsky a Private Message  Reply with Quote
Padraic,
It works great Thanks
RBS
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ForumCo Support Forums © 2000 - 2010 ForumCo.com Go To Top Of Page
This page was generated in 0.16 seconds. Snitz Forums 2000
RSS Feed 1 RSS Feed 2
Powered by ForumCo 2000-2008
TOS - AUP - URA - Privacy Policy