Myron, Here is a snippet of code I use to find directions using Google; vFrom and vTo are the starting location and destination that re either collected from an address columns or entered manually in the calling form. I have not used it in while and maybe the Google format has changed bit I think it should still work or at least give you an idea on how to structure your command. I have code for MapQuest as well. -- Build destination address SET VAR vTo = (SRPL(.vTo,', ',',',0)) SET VAR vTo = (SRPL(.vTo,',','+',0)) SET VAR vTo = (SRPL(.vTo,' ','+',0)) -- Build starting address SET VAR vFrom = (SRPL(.vFrom,', ',',',0)) SET VAR vFrom = (SRPL(.vFrom,',','+',0)) SET VAR vFrom = (SRPL(.vFrom,' ','+',0)) *( -- Format for Link for Google Directions http://maps.google.com/maps?saddr=12345+South+Twilight+Lane,+Olathe,+KS+66062 <http://maps.google.com/maps?saddr=12345+South+Twilight+Lane,+Olathe,+KS+66062&daddr=7654+Nall+Avenue,+Prairie+Village,+KS+66208> &daddr=7654+Nall+Avenue,+Prairie+Village,+KS+66208 ) SET VAR vpart1 TEXT = + 'http://maps.google.com/maps?saddr=' SET VAR vhtml TEXT = (.vpart1 + .vFrom + '&daddr=' + .vTo) LAUNCH .vhtml CLEAR VAR vTo, vFrom, vhtml, vpart1 RETURN Javier, Javier Valencia, PE 913-915-3137 From: [email protected] <[email protected]> On Behalf Of [email protected] Sent: Monday, January 10, 2022 8:54 AM To: [email protected] Subject: [RBASE-L] - Converting a Variable to Text Goal: To have R:Base create a full text launch command to be used with a browser. The final command that I will need to put in browser will look like the one below. I can get a variable for the street address from the database as a variable, say for the property address (20450 N Stardust Blvd) but I need to convert the variable to text as shown below. (One text string). Yes, I did hit the wall. LAUNCH https://www.google.com/maps/search/ +20450 N Stardust Blvd + Sun City West + AZ + 85375 Thanks for your help. Myron Finegold, Sheriff’s Posse of Sun City West -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/033601d80631%24e6a5cf60%24b3f16e20%24%40gmail.com <https://groups.google.com/d/msgid/rbase-l/033601d80631%24e6a5cf60%24b3f16e20%24%40gmail.com?utm_medium=email&utm_source=footer> .
-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAG1gU%2BA71stIig71BAFnx9iihQAAEAAAALpPgtTKbC5Cgw6UO3yU8v4BAAAAAA%3D%3D%40vtgonline.com.
