| User: editor -- 2012-09-27 << 1007 1009 >> |
| Hits: 3438 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| How to convert csv files into tables with html format? |
| Input Sample: |
| a,b,c,d e,f,g,h i,j,k,l |
| Output Sample: |
| <table border=1> <tr> <td>a<td> <td>b<td> <td>c<td> <td>d<td> </tr> <tr> <td>e<td> <td>f<td> <td>g<td> <td>h<td> </tr> <tr> <td>i<td> <td>j<td> <td>k<td> <td>l<td> </tr> </table> |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open csv file 2. ctrl-h open 'replace' dialogue * set 'replace unit' to 'Line' * set 'replace with pattern' to: * click 'advanced' tab: * set 'insert begin text' to: * set 'insert end text' to: 3. click 'replace', done. 4. note: for multiple files, click "Batch..." and drag multiple files to "batch runner" window, and click "batch replace", done. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |