Windows Scripting - Editing Text File

Question

C:\Incoming\records.txt

11 record(s) received

5021462426325

5021462426325

5021462426325

5021462426325

5021462426325

8901090213511

8901090213511

8901090213511

8901090213511

0080432400708

0080432400708

The desired format of the file contents

5021462426325,5021462426325,5021462426325,5021462426325,5021462426325,8901090213511,8901090213511,8901090213511,8901090213511,0080432400708,0080432400708

Then copy this from C:\Incoming to C:\Outgoing and place the old file in C:\Stored.

I'd learn Powershell or install Windows ports of some standard UNIX/Linux tools for scripting. — Alexey Frunze
– Alexey Frunze, Commented Sep 14, 2012 at 13:17
That is precisely the constraint, else I could have easily done that. — shoonya
– shoonya, Commented Sep 14, 2012 at 13:18

Bali C · Accepted Answer · 2012-09-14 13:44:15Z

1

for /f "tokens=* skip=1" %%i in (C:\Incoming\records.txt) do echo|set /p="%%i,">>C:\Outgoing\records.txt
move C:\Incoming\records.txt C:\Stored\records.txt

answered Sep 14, 2012 at 13:44

Bali C

31.4k37 gold badges128 silver badges155 bronze badges

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

4 Comments

shoonya Over a year ago

There is a preceding comma and Can I just do a wildcard with the file name? --- The output is ,5021462426325,5021462426325,5021462426325,5021462426325,5021462426325,8901090213511,8901090213511,8901090213511,8901090213511,

Bali C Over a year ago

No, you can't use a wildcard. I just copied your text and there is no proceeding comma, have you edited the command? There is a comma at the end actually, but not at the start.

shoonya Over a year ago

Okie, I think I understand what the issue might be. There is a newline between the first record and the line "11 record(s) received". How do i handle that?

dbenham Over a year ago

@shoonya - Change skip=1 to skip=2.

Collectives™ on Stack Overflow

Windows Scripting - Editing Text File

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related