Getting rid of white space between name, number and height

Question

I have txt file like this;

name lastname     17      189cm

How do I get it to be like this?

name lastname, 17, 189cm

What have you attempted? Do you have any sample code you have tried that we could help fix to get it to work? — , Nov 05 '21 at 19:32
Need an MRE or at least some code to show what you have attempted or even began. — troy, Nov 05 '21 at 19:32
What is the actual separator between the fields? Could it be TAB? — Barmar, Nov 05 '21 at 19:33
Why is there no comma between `name` and `lastname` in the result? How is that whitespace distinguished from the others? — Barmar, Nov 05 '21 at 19:33

Алексей Р · Answer 1 · 2021-11-05T19:46:37.167

1

text = 'name lastname     17      189cm'
out = ', '.join(text.rsplit(maxsplit=2)) # if sep is not provided then any consecutive whitespace is a separator
print(out) # name lastname, 17, 189cm

edited Nov 05 '21 at 19:46

answered Nov 05 '21 at 19:33

Алексей Р

7,507
2
7
18

RJ Adriaansen · Answer 2 · 2021-11-05T19:46:06.947

1

You can use regex to replace multiple spaces (or tabs) with a comma:

import re

text = 'name lastname     17      189cm'
re.sub(r'\s\s+|\t', ', ', text)

edited Nov 05 '21 at 19:46

answered Nov 05 '21 at 19:36

RJ Adriaansen

9,131
2
12
26

score 1 · Answer 3 · answered Nov 05 '21 at 19:42

1

Using str.strip and str.split:

>>> my_string = 'name lastname     17      189cm'
>>> s = list(map(str.strip, my_string.split()))
>>> ', '.join([' '.join(s[:2]), *s[2:] ])
'name lastname, 17, 189cm'

answered Nov 05 '21 at 19:42

Jab

26,853
21
75
114

score 0 · Answer 4 · answered Nov 05 '21 at 19:36

0

You could use re.sub:

import re
s = "name lastname       17         189cm"
re.sub("[ ]{2,}",", ", s)

PS: for the first problem you proposed, I had the following solution:

s = "name lastname 17 189cm"
s[::-1].replace(" ",",", 2)[::-1]

answered Nov 05 '21 at 19:36

nikeros

3,302
2
10
26

Getting rid of white space between name, number and height

4 Answers4