h8rt3rmin8r

normalizeLongitude.airtable

Dec 6th, 2019
196
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CONCATENATE(IF(FIND("-",IF(SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".","")="","0",SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".","")))>0,CONCATENATE("1",RIGHT(CONCATENATE("000",SUBSTITUTE(IF(SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".","")="","0",SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".","")),"-","")),3)),CONCATENATE("2",RIGHT(CONCATENATE("000",IF(SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".","")="","0",SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".",""))),3))),LEFT(IF(SUBSTITUTE(SUBSTITUTE(longitude,IF(SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".","")="","0",SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".","")),""),".","")="","0000",SUBSTITUTE(SUBSTITUTE(longitude,IF(SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".","")="","0",SUBSTITUTE(IF(FIND(".",longitude)=0,longitude,LEFT(longitude,FIND(".",longitude))),".","")),""),".","")),4))
RAW Paste Data