How would I make a program that removes all of the letters and the commas after them from a txt document?

Question

I have a giant text document that looks sort of like this:

A,1,2,3
B,2,5,3
C,7,9,0
.
.
.

How would I write a program that would make the text document look like this:

(Basically the letters and the commas after the letter are removed, and all commas after the first number change into spaces)

Possible duplicate of [Deleting columns in a CSV with python](https://stackoverflow.com/questions/7588934/deleting-columns-in-a-csv-with-python) — SanSolo, Dec 17 '18 at 05:27

score 1 · Answer 1 · answered Dec 17 '18 at 05:01

1

You'll want to call the following on each line:

line.split(',')[1:]

This splits the line along the commas, and then slices off the first element.

answered Dec 17 '18 at 05:01

alexgolec

26,898
33
107
159

This didn't really work. The new lines ended up being the same as the old ones – M. Chak Dec 17 '18 at 05:16
That's because the code is incomplete and meant more as a hint, I presume. – Jan Christoph Terasa Dec 17 '18 at 06:55

Jan Christoph Terasa · Answer 2 · 2018-12-17T07:18:00.903

0

If you're on Linux/Unix you can use basic shell commands, which should be available everywhere:

cut -d "," -f 2- --output-delimiter=" " input.txt > output.txt

If you insist on using Python, you can do:

with open('input.txt', 'r') as infile, open('output.txt', 'w') as outfile:
    for line in infile:
        outfile.write(' '.join(line.split(',')[1:]))

edited Dec 17 '18 at 07:18

answered Dec 17 '18 at 07:09

Jan Christoph Terasa

5,781
24
34

How would I make a program that removes all of the letters and the commas after them from a txt document?

2 Answers2