l_row[0] = l_slug
# addres cleanup
l_row[17] = re.sub('([;,:\.])[;,:\.]', r'\1', l_row[17])
# geolocalization
if l_geoLoc:
# 17 address
l_address = l_row[17]
if not re.search('98000\s+MONACO', l_address):
l_address = re.sub('\s+', ' ', l_address + ' france').strip()
else:
l_address = re.sub('\s+', ' ', l_address).strip()
l_lat, l_long = CommonFunctions.getLatLong(l_address)
if l_lat is not None:
# 18 latitude
# 19 longitude
l_row[18] = str(l_lat)
l_row[19] = str(l_long)
# 20 streetview
l_row[20] = '1'
l_geoMetatags = re.sub('\s+', ' ', ''"""
<meta name="geo.placename" content="{0}" />
<meta name="geo.position" content="{1};{2}" />
<meta name="geo.region" content="FR-" />
<meta name="ICBM" content="{1}, {2}" />
""".format(l_address, l_lat, l_long)).strip()
