CODEWITHSUNDEEP
pythonpython-3.x
I'm in the trenches relax
I'm in the trenches relax

Reputation: 31

Add comma between text

I have a list of addresses in a text document and I want to add a comma after address line 1, and then save it all to a new text document.

example my list of addresses are

Address 1404 756 48 Stockholm
Address 9 756 52 Stockholm
Address 53 B lgh 1001 619 34 Stockholm
Address 72 B lgh 1101 619 30 Stockholm
Address 52 A 619 33 Stockholm

What I want the output to be

Address 1404, 756 48 Stockholm
Address 9, 756 52 Stockholm
Address 53 B lgh 1001, 619 34 Stockholm
Address 72 B lgh 1101, 619 30 Stockholm
Address 52 A, 619 33 Stockholm

I can't figure out how to accurately place the comma at the right place (before the zip code) since the amount of whitespace isn't the same for all addresses. The zip code consists of 5 digits for instance (756 48).

Upvotes: 0

Views: 90

Answers (5)

larapsodia
larapsodia

Reputation: 624

If your postal code and city are limited to the format shown here (three digits, space, two digits, space, one word), then you can do this with a regular expression. It just needs to look for the postal code and city pattern, and capture both it and whatever comes before it, adding a comma in between:

>>> import re
>>> address_list = ['Address 1404 756 48 Stockholm', 'Address 9 756 52 Stockholm', 
'Address 53 B lgh 1001 619 34 Stockholm', 'Address 72 B lgh 1101 619 30 Stockholm', 
'Address 52 A 619 33 Stockholm']

# Define regex pattern as space+3digits+space+2digits+word.
# Parens capture both that pattern and everything before it (.*)
>>> p = re.compile(r"(.*)( \d{3} \d{2} \w+)")

# Create a new list, replacing each item with group1+comma+group2
>>> new_addresses = [re.sub(p, r"\1,\2", a) for a in address_list]

>>> for a in new_addresses: print(a)                                                               

'Address 1404, 756 48 Stockholm'
'Address 9, 756 52 Stockholm'
'Address 53 B lgh 1001, 619 34 Stockholm'
'Address 72 B lgh 1101, 619 30 Stockholm'
'Address 52 A, 619 33 Stockholm'

If the patterns can be different than the examples you gave here (if a city can have two words, etc.) then you can still do this, you would just need to tweak the regex to match those patterns too.

Upvotes: 0

Ammar_Asim_23
Ammar_Asim_23

Reputation: 5

s='''Address 1404 756 48 Stockholm
Address 9 756 52 Stockholm
Address 53 B lgh 1001 619 34 Stockholm
Address 72 B lgh 1101 619 30 Stockholm
Address 52 A 619 33 Stockholm'''
lis=s.split('\n')
lis1=[i.split(' ') for i in lis]
for i in lis1:
    for j in i:
        if i.index(j) == 1:
            lis1[lis1.index(i)][i.index(j)] = j +','

lis1=[' '.join(i) for i in lis1]
lis1='\n'.join(lis1)
print(lis1)

Upvotes: 0

Remzinho
Remzinho

Reputation: 549

Try this:

with open('sample.txt') as file:
  df = file.read()
  for line in df.split('\n'):
    split_line = line.split()
    split_line.insert(-3, ',')
    new_line = " ".join(elem for elem in split_line).strip()
    print(new_line)

Output:

Address 1404 , 756 48 Stockholm
Address 9 , 756 52 Stockholm
Address 53 B lgh 1001 , 619 34 Stockholm
Address 72 B lgh 1101 , 619 30 Stockholm
Address 52 A , 619 33 Stockholm

The extra space before the commas can be adressed with a strip() further down.

Upvotes: -1

chrslg
chrslg

Reputation: 13336

With regexp

import re
re.sub(r'\s(\d{3}\s\d{2}\s.*)$', ', \\1', 'Address 53 B lgh 1001 619 34 Stockholm')
# 'Address 53 B lgh 1001, 619 34\xa0Stockholm'

(the \xa0 is part of your strings. It will print as a space)

Upvotes: 2

Fedor Soldatkin
Fedor Soldatkin

Reputation: 1203

You can use str.rstrip() to separate city and index from the first line:

file_line = 'Address 72 B lgh 1101 619 30 Stockholm'

# Use maxsplit=3
first_line, *second_line = address.rsplit(' ', 3)

new_address = f'{first_line}, {' '.join(second_line)}'

Upvotes: 0

Related Questions