CSV to html – search in columns

Search

It’s easy to implement basic search functionality. The search functionality search through the table with a a wildcard-filter in each visible column.

Original

SR.NAMEGENDERAGEDATE COUNTRY
1Dett2Female3616/08/2020Great Britain
2Nern Female1915/10/2017France
3KallsieMale2016/08/2016France
4SiuauFemale2121/05/2015Great Britain
5ShenniceMale2221/05/2016France
6ChasseFemale2315/10/2018France
7TommyeMale2416/08/2017United States
8DorcastFemale2521/05/2016United States
9AngeleeMale2621/05/2017Great Britain
10WilloomFemale2615/10/2019France

Select columns to search in

By default all columns are searched in. If you want to search in one or more specific column – you can use search_cols in format col,col,col or col from-col to or a combination (e.g. 1,4,5 or 1-5 or 1,2,3-5) or just the specific column name(s) (e.g. age, name).

In the example below we only want to search for 9 in the age-column (4):

[csvtohtml_create source_type="guess" source_files="free_testdata_10rows.csv" search_functionality="yes" search_highlightcolor ="lightgreen" search_cols="4"]
SR.NAMEGENDERAGEDATE COUNTRY
1Dett2Female3616/08/2020Great Britain
2Nern Female1915/10/2017France
3KallsieMale2016/08/2016France
4SiuauFemale2121/05/2015Great Britain
5ShenniceMale2221/05/2016France
6ChasseFemale2315/10/2018France
7TommyeMale2416/08/2017United States
8DorcastFemale2521/05/2016United States
9AngeleeMale2621/05/2017Great Britain
10WilloomFemale2615/10/2019France

And this would result in:

SR.NAMEGENDERAGEDATE COUNTRY
2Nern Female1915/10/2017France