Toda la lista de comando y expresiones y utilizadas durante el tutorial, para que te sea más sencillo.
1. value.replace(‘.o’,’’)
2. ‘AVENIDA ’+value.replace(‘.AV’,’’)
3. value.substring(3,5)
4. value.facetCount(“value”, “Fecha de Rodaje”)
5. 'http://maps.google.com/maps/api/geocode/xml?address=' + cells['Número'].value+ '+' +value.replace(' ','+') + '&components=locality:CF|administrative_area:Ciudad+Aut%C3%B3noma+de+Buenos+Aires|country:AR&sensor=false&language=es'
6. value.replace(‘Ñ’,’N’)
7. value.replace(“‘“,’+’)
8. trim(value.parseHtml().select("status")[0].toString().unescape("html").replace('<status>','').replace('</status>',''))
9.
trim(value.parseHtml().select("formatted_address")[0].toString().unescape("html").replace('<formatted_address>','').replace('</formatted_address>',''))
10. if(trim(value.parseHtml().select("address_component")[2].select("type")[0].toString().unescape("html").replace('<type>','').replace('</type>',''))==’neighborhood’,value.parseHtml().select("address_component")[2].select("long_name")[0].toString().unescape("html").replace('<long_name>','').replace('</long_name>','')),if(trim(value.parseHtml().select("address_component")[1].select("type")[0].toString().unescape("html").replace('<type>','').replace('</type>',''))==’neighborhood’,value.parseHtml().select("address_component")[1].select("long_name")[0].toString().unescape("html").replace('<long_name>','').replace('</long_name>','')),if(trim(value.parseHtml().select("address_component")[0].select("type")[0].toString().unescape("html").replace('<type>','').replace('</type>',''))==’neighborhood’,value.parseHtml().select("address_component")[0].select("long_name")[0].toString().unescape("html").replace('<long_name>','').replace('</long_name>','')),’’)
11. trim(value.parseHtml().select("geometry")[0].select("lng")[0].toString().unescape("html").replace('<lng>','').replace('</lng>',''))
12.
trim(value.parseHtml().select("geometry")[0].select("lat")[0].toString().unescape("html").replace('<lat>','').replace('</lat>',''))