Hi Bill, Thank you for your quick reply. A few days ago I managed to get the same result, but... the 'final' result we both get was the short Pluscode in column 1 and the place name comes in column 2. Of course there is an option to combine these two columns by making use of an other function. The function Pluscode_to_address is creating the illusion that the entire result of this function will be presented into only one column. If you are making use of Google Maps then you can see that the details of a selected place wil inform you with a short pluscode-syntax.
I am using the short Pluscode to identify an audio-file with the name of this Pluscode. This audio file will be used in a waypoint what will be part of a route in a Garmin Navigation device. The waypoint is 'playing' its MP3-file when you are nearby the place of the particular waypoint. No more reading in a guide during my bicycle-trip but a sweet-voice who is informing about the highlight I am passing during this trip. Anyway thank you for spending your time in this case and if you can find a way how to program the short Pluscode-syntax in the way that the result will come into one column, please feel free to sent me one more message. Kind regards, Peter Drukker BlueMail voor Android downloaden Op 24 aug. 2022 20:58, om 20:58, Bill Steinmetz <bill...@google.com> schreef: >Hi Peter, > >PLUSCODE_TO_ADDRESS outputs two columns, with the place name in the >second >column. Are you seeing Buenos Aires there? > >Here's an example (assuming there's a locality table defined in >B26:C30): > >Input Function Output (2 columns) >7JWVJ67W+45 =PLUSCODE_TO_ADDRESS(B35, $B$26:$C$30) J67W+45 Delhi >7HP8PQJG+J5X =PLUSCODE_TO_ADDRESS(B36, $B$26:$C$30) PQJG+J5X Riyadh >8Q7XPWH5+V83 =PLUSCODE_TO_ADDRESS(B37, $B$26:$C$30) PWH5+V83 Tokyo > >Cheers, Bill > >On Wed, Aug 24, 2022 at 11:52 AM Peter Drukker <pdruk...@gmail.com> >wrote: > >> Making pluscode in Google Sheets is no problem but... generating a >short >> Pluscode with the locationname is a problem (for me). >> I am making use of the Pluscode-addon in Google Sheets. One of the >> functions in this addon is the 'Convert to addresses' option. By >using this >> function the result of the functions only shows me the 6 first >characters >> but not the place name : 9HR7+CG Behind CG i am expecting Buenos >Aires >> because the full Pluscode is 48Q39HR7+CG. >> >> Is there an option/function/script available to make a simple >translation >> from the full Pluscode to a short and meaningfull Pluscode including >a >> locationname? >> The short pluscode can be usefull for giving my Points Of Interest >> (POI)-files the name of this short pluscode. >> >> -- >> Public site: http://www.openlocationcode.com/ >> Github project: https://github.com/google/open-location-code >> Demo site: http://plus.codes/ >> --- >> You received this message because you are subscribed to the Google >Groups >> "Plus Codes Community Forum" group. >> To unsubscribe from this group and stop receiving emails from it, >send an >> email to open-location-code+unsubscr...@googlegroups.com. >> To view this discussion on the web, visit >> >https://groups.google.com/d/msgid/open-location-code/30bf90c9-c5e3-4126-80b1-6571e0cb86c9n%40googlegroups.com >> ><https://groups.google.com/d/msgid/open-location-code/30bf90c9-c5e3-4126-80b1-6571e0cb86c9n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> -- Public site: http://www.openlocationcode.com/ Github project: https://github.com/google/open-location-code Demo site: http://plus.codes/ --- You received this message because you are subscribed to the Google Groups "Plus Codes Community Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-location-code+unsubscr...@googlegroups.com. To view this discussion on the web, visit https://groups.google.com/d/msgid/open-location-code/3b1540fd-f947-40d5-a5f5-1ad16a153d7b%40gmail.com.
