Batch commands to swap text from file

Question

This is the input file:-

Hello,1-23456
How are you,2-34567
.
.
.

I want output:-

1-23456,Hello
2-34567,How are you
.
.
.

Please help me to create a batch file for this.

I have tried this

@echo off &setlocal

set "textfile=inputchq.csv"
set "newfile=output.txt"

(for /f "tokens=1,2 delims=," %%i in (%textfile%) do set srno=%%a&set comments=%%b (
    set "line=%%i"
    setlocal enabledelayedexpansion
set "line=%comments%,%srno%"
    echo(!line!
    endlocal
))>>"%newfile%"

But i am not getting the desired output

What have you tried? Please attempt to solve your own questions before asking them here, and add what you have come up with to your question. — BDM
– BDM, Commented Mar 6, 2016 at 7:53
I have attempted to this problem, please take a look and help me — bhavik sanghvi
– bhavik sanghvi, Commented Mar 6, 2016 at 10:26

Stephan · Accepted Answer · 2016-03-06 16:42:19Z

0

@echo off &setlocal

set "textfile=inputchq.csv"
set "newfile=output.txt"

(for /f "tokens=1,2 delims=," %%a in (%textfile%) do (
    echo %%b,%%a"
))>>"%newfile%"

Edit to match additional requirement from comment:

you need delayed expansion and to escape the special character "|"

@echo off 
setlocal enabledelayedexpansion

set "textfile=inputchq.csv"
set "newfile=output.txt"

(for /f "tokens=1,2 delims=," %%a in (%textfile%) do (
    set "line=%%b,%%a"
    echo !line:^|=.!
))>>%newfile%

edited Mar 6, 2016 at 16:42

answered Mar 6, 2016 at 10:34

Stephan

56.7k11 gold badges66 silver badges97 bronze badges

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

1 Comment

bhavik sanghvi Over a year ago

In this same solution i want to replace all "|" with "." where can i add in this loop.Please help.

Collectives™ on Stack Overflow

Batch commands to swap text from file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related