Hi, I want to store Latitude and Longitude values in single field while storing directly into the database.
How can i combine two values in one text field? Tried with append, +, arbitrary text, nothing working. Please help. Thank you.
Hi, I want to store Latitude and Longitude values in single field while storing directly into the database.
How can i combine two values in one text field? Tried with append, +, arbitrary text, nothing working. Please help. Thank you.
Iād say
latitude :append && :append longitude
This assumes that your longitude and latitude values are text (and not number) and feel free to replace ā&&ā by anything you want to separate both long and lat in the combined text.
To extract the data, you would then use :splitby and && as the text separator