How to generate a comma separated string using for loop with batch script / powershell in a single line

Question

I have a text file with id's separated by new line

I want this text file to be comma separated using Batch script

Refer my code below, this code generates Comma seperated string but still with new line. I want the comma seperated string in single line

@echo on & setlocal ENABLEDELAYEDEXPANSION 
for /f "tokens=* delims=" %%a in (input.txt) do (
set /a N+=1
echo ^%%a^,>>output.txt
)

input.txt is

Output.txt should be 1,2,3,4,5

lahell · Accepted Answer · 2015-07-07 06:11:25Z

2

This is easier with PowerShell:

(Get-Content input.txt) -join ',' | Out-File output.txt

answered Jul 7, 2015 at 6:11

lahell

663 bronze badges

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

Comments

MC ND · Accepted Answer · 2015-07-07 06:15:47Z

1

@echo off
    setlocal enableextensions disabledelayedexpansion

    set "first=1"
    (for /f "delims=" %%a in (input.txt) do (
        if not defined first ( set /p"=,%%a" ) else ( set /p"=%%a" & set "first=" )
    )) <nul >output.txt

answered Jul 7, 2015 at 6:15

MC ND

71.1k8 gold badges95 silver badges136 bronze badges

Collectives™ on Stack Overflow

How to generate a comma separated string using for loop with batch script / powershell in a single line

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related