Sourcetype guessonecol
If you set the sourcetype to guessonecol then the result would appear in one column (even if there are several columns in the csv-file(s)). This column contains all values from a row and are separated by a span
-tag.
Original
SR. | NAME | GENDER | AGE | DATE | COUNTRY |
---|---|---|---|---|---|
1 | Dett2 | Female | 36 | 16/08/2020 | Great Britain |
2 | Nern | Female | 19 | 15/10/2017 | France |
3 | Kallsie | Male | 20 | 16/08/2016 | France |
4 | Siuau | Female | 21 | 21/05/2015 | Great Britain |
5 | Shennice | Male | 22 | 21/05/2016 | France |
6 | Chasse | Female | 23 | 15/10/2018 | France |
7 | Tommye | Male | 24 | 16/08/2017 | United States |
8 | Dorcast | Female | 25 | 21/05/2016 | United States |
9 | Angelee | Male | 26 | 21/05/2017 | Great Britain |
10 | Willoom | Female | 26 | 15/10/2019 | France |
Sourcetype guessonecol
[csvtohtml_create source_type="guessonecol" source_files="free_testdata_10rows.csv"]
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 |
Header
When using this sourcetype, it removes all headers in all columns, but the header is still in the table, but with empty values. That’s why you see like a border in the example above. If you want to set a header, you can use the setting/attribute title.
[csvtohtml_create source_type="guessonecol" source_files="free_testdata_10rows.csv" title="Members"]
Members |
---|
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 |
Maybe you don’t want to show the headerrow (Members in this case). To handle this, you can simply just add skip_headerrow=”yes”.
[csvtohtml_create source_type="guessonecol" source_files="free_testdata_10rows.csv" skip_headerrow="yes"]
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 |
If you don’t have a headerrow at all in your file, you can simply add headerrow_exists=”no”.