rewrite a txt file

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
oldfox74
Posts: 3
Joined: 19 Nov 2022 05:32

rewrite a txt file

#1 Post by oldfox74 » 19 Nov 2022 05:47

hi to all,
i need help rewriting a test file in a specific way. as i am an amateur, i need your help. the starting file is file.txt like this:

2022-11-19 10:06:01,0,17.14,68.27,12.9,8.8556,10.5928

first part is date/time and is ok
0 is a fixed value in second position that i need to change in a new fixed value (ex. 1132)

after this, in third position i need to add a fixed value that is alwais 2

in 4th position i need the value of the 6th position on the original file

in 5th position i need a fixed value that is alwais 0

the result i need is a new txt file like this:

2022-11-19 10:06:01;1132;2;8.8556;0

thank to all!!!!

oldfox74
Posts: 3
Joined: 19 Nov 2022 05:32

Re: rewrite a txt file

#2 Post by oldfox74 » 19 Nov 2022 11:23

i resolve the problem... but i need last help!!!!
here the script:

@echo
cd C:\polaris\test
ren *.csv file.txt
set "txt=C:\polaris\test\file.txt"
more +2 "%txt%" >"%txt%.new"
move /y "%txt%.new" "%txt%" >nul
for /f "tokens=1,2,3,4,5,6,7* usebackq delims=," %%a in ("C:\polaris\test\file.txt") do echo %%a;3100;2;%%f;0;>>C:\polaris\test\file2.txt

input:
xxxxxxxxxxxx
xxxxxxxxxxxx
2022-11-19 10:06:01,0,17.14,68.27,12.9,8.8556,10.5928

output:
2022-11-19 10:06:01;3100;2;8.8556;0;

i need to remove the ; after the last 0

right output:
2022-11-19 10:06:01;3100;2;8.8556;0

miskox
Posts: 553
Joined: 28 Jun 2010 03:46

Re: rewrite a txt file

#3 Post by miskox » 19 Nov 2022 12:47

FOR /F is your friend (type HELP FOR from the command prompt):

In your file.txt you have:

Code: Select all

2022-11-19 10:06:01,0,17.14,68.27,12.9,8.8556,10.5928
Put this into a .bat/.cmd file:

Code: Select all

@echo off
REM fields:  f          g   h     i     j    k       l  (note:small letter L)
REM 2022-11-19 10:06:01,0,17.14,68.27,12.9,8.8556,10.5928
REM so we have 7 letters (from 'f' to 'l'. So we need 7 tokens)
for /f "tokens=1-7 delims=," %%f in (file.txt) do echo %%f,%%g,%%h,%%i,%%j,%%k,%%l
Output looks like this:

Code: Select all

2022-11-19 10:06:01,0,17.14,68.27,12.9,8.8556,10.5928
So you see output is exactly as your input. Rearrange variables %%f ... %%l to suit your needs. %%f represents first field (delimited by comma), %%g is the second field etc.

So your code would look like this:

Code: Select all

@echo off
REM fields:  f          g   h     i     j    k       l  (note:small letter L)
REM 2022-11-19 10:06:01,0,17.14,68.27,12.9,8.8556,10.5928
REM so we have 7 letters (from 'f' to 'l'. So we need 7 tokens)
REM here we create an empty file
break>new_file.txt
REM note: now commas (,) are replaced by semicolons (;) as per your post
for /f "tokens=1-7 delims=," %%f in (file.txt) do (echo %%f;1132;2;%%k;0)>>new_file.txt
Result:

Code: Select all

2022-11-19 10:06:01;1132;2;8.8556;0
Note that I changed comma for a semicolon!

Saso

oldfox74
Posts: 3
Joined: 19 Nov 2022 05:32

Re: rewrite a txt file

#4 Post by oldfox74 » 19 Nov 2022 13:42

thanks Saso,
i try to do it in my way:

for /f "tokens=1,2,3,4,5,6,7* usebackq delims=," %%a in ("C:\polaris\test\file.txt") do echo %%a,3100,2,%%f,0;>>C:\polaris\test\file2.txt
but i had a ; at the end

but your solution is better (there is no ; at the end)

OJBakker
Expert
Posts: 88
Joined: 12 Aug 2011 13:57

Re: rewrite a txt file

#5 Post by OJBakker » 20 Nov 2022 02:42

You do not need the ; if you place the redirection to file at the start of the line.

Code: Select all

>>C:\polaris\test\file2.txt for /f "tokens=1,2,3,4,5,6,7* usebackq delims=," %%a in ("C:\polaris\test\file.txt") do echo %%a,3100,2,%%f,0
My guess is that you added the ; to get the redirection working.
A special feature of redirection is that a digit immediately preceding the redirection becomes part of the redirection and will not be send as redirected output. This digit represents the type of output, with the default value of 1, meaning normal text output.

Post Reply