In order to prepare data for visualizing in Map, I need to re-format column with “city” name, because currently it contain number of city district like “Praha 1”. BTW, there are also correct strings like “Český Krumlov”. To remove district number, I created Custom column with FIELD FORMULA
=regexextract([CITY], " *[a-zA-Z-.áčďéěíňóřšťůúýžÁČĎÉĚÍŇÓŘŠŤŮÚÝŽ]+")
but preview or visualize fails with below message:
# There was a problem with your question
Most of the time this is caused by an invalid selection or bad input value. Double check your inputs and retry your query.
## Here’s the full error message
No method in multimethod ‘->honeysql’ for dispatch value: [:sqlserver :regex-match-first]
Is my regex bad ? Or where is problem ? My question is without filter, just Summarize - Count by “Custom column”