Skip Navigation

[Resolved] searching for a table row, via a column which includes separated text

This support ticket is created 4 years, 1 month ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 1 reply, has 2 voices.

Last updated by Luo Yang 4 years, 1 month ago.

Assisted by: Luo Yang.

Author
Posts
#2242991
example for Types_WP Ultimate CSV Importer.png

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.

#2243265

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