Solved

Need Help with a Loop

Posted on 1999-01-14
8
143 Views
Last Modified: 2010-05-03
I am currently doing a project which lets me be able to tell the time of a place using the longitude and latitude.  I also need to use a type of WHile loop.  How do i assign a vlaue to the numbers in the longitude and latitude in order to figure out the time? THANX
0
Comment
Question by:Peanuthead
8 Comments
 
LVL 1

Expert Comment

by:twolff
ID: 1456278
Need more information.
> Do you want to assign the lat and lon that is kept somewhere to variables?

> Or are you wanting the actual calculation
0
 
LVL 3

Expert Comment

by:traygreen
ID: 1456279
Not sure what you would need a loop here for.
I would think you would define areas of lat/long and their corresponding offsets to GMT and go from there

0
 
LVL 6

Expert Comment

by:clifABB
ID: 1456280
Time doesn't change based on latitude.
There is one hour difference for each 15 degrees longitude.
0
 
LVL 6

Expert Comment

by:clifABB
ID: 1456281
To expand on that, you might have the following as a calculation:

Hour = GMT + (Longitude \ 15)
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:Peanuthead
ID: 1456282
Sorry, my retarded friend typed that in....the project im doing for school requires me to extract the longitude from a text file with a list of about 50 cities in this format:
Washington 24 30 Long 100 45 Lat E
etc....
etc....
somewhat like that
now, i need to have a drop down combobox that the user can select from that allows them to select one of those cities.  i figured that part out..its pretty damned easy. WHAT I NEED TO KNOW:
How do i get the longitude outta that.  And how do i get the "E" or "W" out of it too.(For "E"ast or "W"est of the prime meridian.)  THAT is what used a while loop.  Thats all i need to know.  After i can do that the rest is easy.  thanks and sorry about my stupid friend ;)
0
 
LVL 1

Accepted Solution

by:
Johnn earned 50 total points
ID: 1456283
I'm not really good at reading text files but I assume you can read them one line at a time so do something like this
dim thisline as string
dim eastwest$
dim cityend%
dim cityname$
dim longitude$
dim cboIndex() as string's/b declared in general declarations
While not EOF
    thisline=however you read a line
    eastwest=right$(thisline,1)'get the last character
    cityend%=instr(1,thisline," ")-1
    cityname=left$(thisline,cityend)
    longitude=mid$(thisline,cityend+2,instr(cityend+2,thisline,"L")-1
    combo.additem cityname
    redim preserve cboIndex(0 to combo.listcount-1)
    cboindex(ubound(cboindex))=longitude
wend
'in click event of cboindex retrieve longitute like this
longitute=cboindex(combo.listindex)
0
 
LVL 1

Expert Comment

by:twolff
ID: 1456284
The answer from Johnn will work, but may I suggest using a collection to hold the information. You could create a class with a property for each line read from the text file.

Also, if your line is always delimited and not fixed length. I would suggest writing a function that you pass the string and the delimiter and it will extract the information and return it to you. This way you can take the code to any application. I have many modules of such funtions, that I carry to every job.


0
 
LVL 1

Expert Comment

by:twolff
ID: 1456285
If you want more information(samples), just let me know. Also, what version of VB are you using?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now