Is it possible/How-to split data from 1 column into multiple columns for export to csv or excel?

Is it possible/How-to split data from 1 column into multiple columns for export to csv or excel?

kdatabsttabkdatabsttab Posts: 2Questions: 2Answers: 0

Thank you for this incredibly useful package. Working on export using buttons and have a table where certain <td> cells have multiple rows of information separated by <br>. This is to not have such a wide table with many columns, but now for export I'd like to be able to split some of these cells into multiple rows.
For example:

    <td>
          example@example.com
           <br>
          555-555-5555
            <br>
          1234 Main Street
             <br>
           Anytown, Anyplace
    </td>

Is is there a way to export this <td> into four columns (email, phone, street, city?). Thanks for any guidance. If it's not possible, that would be helpful to know as well.

This discussion has been closed.