How to replace "/" by ";" in files .log to .csv using batch on windows

Question

I have many files *.log containing the following lines:

11111/3333/45555/6666/2222//7777

and I need to replace all the "/" by ";" producing the following result:

11111;3333;45555;6666;2222;;7777

But the result must be in a file of the same name but just a differente extension: *.csv. How can I do this using ms-dos batch on windows? PS: I can't use .net, perl, vbscript or some library. This script if for a job interview and they want to test if I know Windows scripting.

I already tried to start but is not working...

@echo off
setlocal ENABLEDELAYEDEXPANSION
for /f "delims='/' tokens=*" %%i in ('findstr "\/" Input.txt') do (
    echo %%i
    set str=%%i
    set myvar=";"
    set str=%str:"/"=!myvar!%
    echo %str%
)

Many thanks in advance.

score 2 · Accepted Answer · answered Jul 08 '14 at 00:01

2

Like this :

@echo off 
setlocal enabledelayedexpansion
for  %%a in (*.log) do (
  echo Working : %%a
  for /f "delims=" %%b in ('type %%a') do (
     set "$Line=%%b"
     set "$Line=!$Line:/=;!"
     echo !$Line!>>%%~na.csv)
 echo Done...
)

answered Jul 08 '14 at 00:01

SachaDee

9,245
3
23
33

Question: can you explain how this works? I understood everything less the part "echo !$Line!>>%%~na.csv)" – Arthur Accioly Jul 08 '14 at 00:08
1

It just get the name without the extension using the modifier `~n`. – SachaDee Jul 08 '14 at 00:13

score 0 · Answer 2 · answered Jul 07 '14 at 23:42

0

This uses a helper batch file called repl.bat (by dbenham) - download from: https://www.dropbox.com/s/qidqwztmetbvklt/repl.bat

Place repl.bat in the same folder as the batch file or in a folder that is on the path.

@echo off
for %%a in (*.log) do type "%%a" |repl "/" ";" L > "%%~na.csv"

answered Jul 07 '14 at 23:42

foxidrive

40,353
10
53
68

I can't use this repl.bat because this batch is for an interview that I'm going to have tomorrow. Do you have some solution without this? Thank you. – Arthur Accioly Jul 07 '14 at 23:56

How to replace "/" by ";" in files .log to .csv using batch on windows

2 Answers2

Linked

How to replace "/" by ";" in files *.log to *.csv using batch on windows

2 Answers2

Linked

How to replace "/" by ";" in files .log to .csv using batch on windows