Tell us what you are trying to do?
I need to know how handle bot the import and future data searching needs using couple of columns in my table which have tilde separated variables. For example, here is the contents of my Table row 1 (after the title row), Column U ---- {~H7225~H1254~H430~H853~H8064~H853~H776~}
Once imported into Types custom field plugin in wordpress where I have defined custom fields for this table, ultimately, I would like to search that column U (for a specific value/tag eg. H7225). Eg. Upon initiating a search for H7225 via the wordpress front end, it would find a match in row 1 (one of several possibilities separated by the tilde in that cell) and then would return and selectively display the row results depending on how I program the front end.
Does your Toolset field types and/or wordpress support this functionality? If so, how would I need to structure the CSV import in order to achieve that functionality in the Toolset custom field and subsequently the front end search.
Is there any documentation that you are following? I am following WP Ultimate CSV Importer documentation and also asked question to their presales department to see if their import tool supports the use case.
Is there a similar example that we can see? Yes. In the screen shot attached, is a similar use case. It is displaying selected contents of a single row of data from the table I mentioned above. the Column U that I am referring to would include the search terms {~H7225~H1254~H430~H853~H8064~H853~H776~} which you can see in the formatted table under the heading "Strongs #)
What is the link to your site? It is not live as yet.
Hello,
1) You can follow our document to setup the csv file and import data into Toolset custom fields:
https://toolset.com/course-lesson/how-to-import-content-into-wordpress-using-csv/
The plugin "WP Ultimate CSV Importer" also supports Toolset custom fields:
https://toolset.com/course-lesson/import-csv-ultimate-csv-importer-plugin/
2) And it is possible to filter the result by custom fields with custom search form, see our document:
https://toolset.com/course-lesson/creating-a-custom-search/
In your case, it needs to use "LIKE" comparison, see below document:
https://toolset.com/documentation/user-guides/views/filtering-views-by-custom-fields/
LIKE
Checks if the custom field value is similar to the compare value, using MySQL LIKE operator