I have somehow landed myself with the job of updating my office's Act! database. I have worked out how to get fields from the database and perform very simple matehmatical functions on them, now I'm stuck! I have to find the first half of a postcode, the whole of which is one of my fields in the database, in an excel spreadsheet, and then return the entry two columns down from it, I think I have to use VBScript since that's all that Act! will understand. Please help get me started!!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Absolute beginner having problems!!
- Thread starter jjmf
- Start date
PhillipFoster
Technical User
Hi there jjmf.
Lucky you for being lumbered with Act!!
A Google search for vbscript tutorial returned 147000 hits. If I might suggest - this is a good start.
I knew nothing about vbscript & wsh a few months ago but using the huge resources available on the intarweb I've been able to write some pretty slick code.
Good luck - and when you're stuck on a specific, you'll find that the tek-tips users will usually come up trumps for you.
Regards - Phil.
Lucky you for being lumbered with Act!!
A Google search for vbscript tutorial returned 147000 hits. If I might suggest - this is a good start.
I knew nothing about vbscript & wsh a few months ago but using the huge resources available on the intarweb I've been able to write some pretty slick code.
Good luck - and when you're stuck on a specific, you'll find that the tek-tips users will usually come up trumps for you.
Regards - Phil.
do you have white space in ALL of your postcodes???
if so then you will have
RG12 8XN
RG1 7HJ
in which case you can use InStr(strPostCode, " "
Or something like
strStart = Left(strPostCode, InStr(strPostCode, " ")
strEnd = Right(strPostCode, Len(strPostCode) - InStr(strPostCode, " ")
if you dont have white space then you might have to work through each character of the post code and determine IsNumeric() if it is then test if the next character is numerice, if it is not then you have you point to break the string up.
as for putting the information into excel you will find many threads in this forum on creating references to excel objects and populating cells etc
regards
richard
if so then you will have
RG12 8XN
RG1 7HJ
in which case you can use InStr(strPostCode, " "
Or something like
strStart = Left(strPostCode, InStr(strPostCode, " "
)strEnd = Right(strPostCode, Len(strPostCode) - InStr(strPostCode, " "
)if you dont have white space then you might have to work through each character of the post code and determine IsNumeric() if it is then test if the next character is numerice, if it is not then you have you point to break the string up.
as for putting the information into excel you will find many threads in this forum on creating references to excel objects and populating cells etc
regards
richard
- Status