Short PlusCode generating in Google Sheets

[Peter Drukker]

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. 

[Bill Steinmetz (㌱)]

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

--
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-c...@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.

[Peter Drukker]

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, om 20:58, Bill Steinmetz <bil...@google.com> schreef: