How to write to the second column in .CSV using batch script?

Question

I'm trying to read a column of numbers from the .txt file and place them in the .csv in the second column.

How to define the second column in batch?

for /f "tokens=1 delims= " %%i in (issn.txt) do (
 >>"anzahl.csv" echo %%i

I don't think you can define the second column in batch. I would loop through each line, and re-write it as <existing line> + <second column> — David Glickman
– David Glickman, Commented Feb 28, 2017 at 17:27
IMHO Insufficient information about the files. BTW "tokens=1 delims= " are default values that can be omitted. The opening parenthesis following do has no closing pendant. To have an empty first column simply echo ,%%i — user6811411
– user6811411, Commented Feb 28, 2017 at 18:00
IMHO still insufficient information about the files. Does the csv file have a header? How do you want to associate the entries? One by one? You should read what a minimal reproducible example is — user6811411
– user6811411, Commented Feb 28, 2017 at 18:11
A few lines showing typical input from the two files and expected result would clarify matters enormously. — Magoo
– Magoo, Commented Feb 28, 2017 at 19:05

user6811411 · Accepted Answer · 2017-02-28 19:27:50Z

2

This will create file New-Anzahl.csv which has empty col2's when number of entries in issn.txt is less than anzahl.csv count. Other way around issn.txt overhang is truncated.

@Echo Off & SetLocal EnableDelayedExpansion
Set "FileA=anzahl.csv"
Set "FileB=issn.txt"
<%FileB% (For /f "delims=" %%A in (%FileA%) Do (
    Set "B="&Set /P "B="
    Echo:%%A,!B!
)) >New-%FileA%

answered Feb 28, 2017 at 19:27

user6811411

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

Collectives™ on Stack Overflow

How to write to the second column in .CSV using batch script?

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