How to replace strings in a batch file? Delayed Expansion and for loop is in use

Question

I have this data source RESIDENTIAL.dat sample :

41-22-01-101-601         20   RANCH                 0       0   3   1   0       0       0       01 WALL  CCP  (1 STORY)       0TREATED WOOD                0ALUM., VINYL       0       0FORCED AIR W/ DUCTS        0C    0

It's one row of the data source.I would like to remove all the "-" of the first value for each row , e.g, here it's 41-22-01-101-601.

Here is my bat code:

@echo off
setLocal EnableDelayedExpansion
for /f "tokens=* delims= " %%a in (RESIDENTIAL.dat) do (
set line=%%a 
set chars=!line:~0,16!
set str=!chars:-=!
set pp=!line:%chars%=%str%!
echo !pp!>>residential_new.dat
)

The result I got is

After testing, the problem is here

set pp=!line:%chars%=%str%!

Can anyone help me with it?

Thank you very much!

Are you just trying to get this string 41-22-01-101-601 and make it into this 412201101601? — Squashman
– Squashman, Commented Aug 11, 2016 at 15:07

Stephan · Accepted Answer · 2016-08-11 15:01:28Z

2

if there are tokens, you should use them:

setlocal enabledelayedexpansion
(
  for /f "tokens=1,*" %%a in (RESIDENTIAL.dat) do (
    set first=%%a
    echo !first:-=! %%b
  )
)>residential_new.dat

first token %%a is everything until the first space or tab, the second token %%b is the whole rest after the first space or tab. Do the changes in the first token and output the changed first token plus the "rest-token".

answered Aug 11, 2016 at 15:01

Stephan

56.8k11 gold badges66 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to replace strings in a batch file? Delayed Expansion and for loop is in use

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related