One of my columns has gps coords in it and they are in as xx.xxxxxx-yy.yyyyyy which won't work in it current format as raw input to plot a map. I found I can split it in excel and then use the concat function to put it back together with a "," in between. I'd like to automate that entire process. Any ideas on how to make that happen so that I can pull the data on the fly and just plug it in? I'd like to make this something that I can do often.
Hi @paintbb84
You can use Custom Column with expression functions to split the data:
https://www.metabase.com/docs/latest/users-guide/custom-questions.html#creating-custom-columns
If you want the tables to have that format, then you need to change it at your database - example with a View.