Category Archives: Windows Bash Script

[Windows Bash Script] convert csv to html table

Posted on 2017 年 10 月 18 日 by cowman.chiang

source: How to find and replace a string in text file using batch file just replace “,” with html table tag.

@echo off
setlocal enabledelayedexpansion
set txtfile=%~1
set newfile=Output.html
if exist "%newfile%" del /f /q "%newfile%"
echo ^<table border='1'^> >> %newfile%
for /f "tokens=*" %%a in (%txtfile%) do (
   set newline=%%a
   set newline=^<tr^>^<td^>!newline:,=^</td^>^<td^>!^</td^>^</tr^>
   echo !newline! >> %newfile%
)
echo ^</table^> >> %newfile%

@echo off

setlocal enabledelayedexpansion

set txtfile=%~1

set newfile=Output.html

if exist "%newfile%" del /f /q "%newfile%"

echo ^<table border='1'^> >> %newfile%

for /f "tokens=*" %%a in (%txtfile%) do (

set newline=%%a

set newline=^<tr^>^<td^>!newline:,=^</td^>^<td^>!^</td^>^</tr^>

echo !newline! >> %newfile%

)

echo ^</table^> >> %newfile%

Posted in Windows Bash Script | 1 Comment

Category Archives: Windows Bash Script

[Windows Bash Script] convert csv to html table

Categories