viewof textInput = html`<input type="search" class="form-control inputSearchRight" id="searchCity" placeholder="Digite o Município" name="q">`
data = FileAttachment("files/Matriculas 2010 a 2022 ID.xlsx").xlsx();
searchCityFilter = data.sheet("id").filter(function(element) {
if (textInput.trim() === ""){
return false;
}
var normalizedElementA = element.A.normalize("NFD").replace(/[\u0300-\u036f]/g, "").toLowerCase();
var normalizedTextInput = textInput.normalize("NFD").replace(/[\u0300-\u036f]/g, "").toLowerCase();
return normalizedElementA.startsWith(normalizedTextInput);
})
hideSearch = {
if(textInput == "" || searchCityFilter.length == 0){
changeVisible("searchTab", false);
return;
}
}
showSearch = {
if (searchCityFilter.length > 0){
changeVisible("searchTab", true);
return;
}
}