Tokenizing A Metafield

I am working with a CMS like system, which has a special field defined for use in its forms. This field works similarly to google suggest, executing an sql query behind the scenes

Solution 1:

So your problem is that you want the "autocomplete" field to automatically fill out the form with the values of the fields when selected? If so, you probably either need to change the separator to something that can be easily split using Javascript (such as "|") or modify the SQL query and PHP code to ouput the 3 fields separately as well. This may be harder if you haven't written the autocomplete code yourself