If you have a table where one column is a link and another has some plain text and you want to merge these two together, this would be possible to achieve with grabcontent_col_fromlink and grabcontent_col_tolink
Original
| Company website | Company name | Login email | Id | First name | Last name | profile-image |
|---|---|---|---|---|---|---|
| https://wibergsweb.se/ | Wibergs Web | laura@example.com | 2070 | Laura | Grey | https://wibergsweb.se/wp-content/uploads/pexels-george-dolgikh-1310522.jpg |
| https://google.se/ | craig@example.com | 4081 | Craig | Johnson | no image | |
| https://wibergsweb.se/ | Wibergs Web | mary@example.com | 9346 | Mary | Jenkins | https://wibergsweb.se/wp-content/uploads/pexels-pixabay-415829.jpg |
| https://google.se/ | jamie@example.com | 5079 | Jamie | Smith | no image |
Merge two columns
To merge cells togetether from two columns there are twp attributes that needs to cooperate:grabcontent_col_fromlink and grabcontent_col_tolink.
grabcontent_col_fromlink: This is the column where you have your current link (e.g. https://wibergsweb.se/))
grabcontent_col_tolink: This column’s value (e.g. Wibergs Web) is now the clickable part of the link. When clicked on the link it moves on the link grabbed with grabcontent_col_fromlink.
The example below shows how to achieve this.
Shortcode
[csvtohtml_create source_type="guess" source_files="email.csv" csv_delimiter=";" grabcontent_col_fromlink="Company website" grabcontent_col_tolink="Company name"]
| Company website | Company name | Login email | Id | First name | Last name | profile-image |
|---|---|---|---|---|---|---|
| https://wibergsweb.se/ | Wibergs Web | laura@example.com | 2070 | Laura | Grey | https://wibergsweb.se/wp-content/uploads/pexels-george-dolgikh-1310522.jpg |
| https://google.se/ | craig@example.com | 4081 | Craig | Johnson | no image | |
| https://wibergsweb.se/ | Wibergs Web | mary@example.com | 9346 | Mary | Jenkins | https://wibergsweb.se/wp-content/uploads/pexels-pixabay-415829.jpg |
| https://google.se/ | jamie@example.com | 5079 | Jamie | Smith | no image |
Hide columns
You maybe don’t want both columns to be visible to user after doing this conversion of links. You could use hide_cols to achieve this. In this example it would be relevant to hide the ”Company website” column:
Shortcode
[csvtohtml_create source_type="guess" source_files="email.csv" csv_delimiter=";" grabcontent_col_fromlink="Company website" grabcontent_col_tolink="Company name" hide_cols="Company website"]
| Company name | Login email | Id | First name | Last name | profile-image |
|---|---|---|---|---|---|
| Wibergs Web | laura@example.com | 2070 | Laura | Grey | https://wibergsweb.se/wp-content/uploads/pexels-george-dolgikh-1310522.jpg |
| craig@example.com | 4081 | Craig | Johnson | no image | |
| Wibergs Web | mary@example.com | 9346 | Mary | Jenkins | https://wibergsweb.se/wp-content/uploads/pexels-pixabay-415829.jpg |
| jamie@example.com | 5079 | Jamie | Smith | no image |