Extracting structured data from semi structured data
I am making the following assumptions:

The first column of numbers is the first few digits/numbers in each line
The last column of numbers is the last few digits/numbers in each line
So, in the second column, texts like MALL1ETAGE ZARA1st FLOOR should not have numbers in the front or end. So, 20215652671MALL1ETAGE ZARA1st FLOOR 2345561 will be interpreted as 20215652671, MALL1ETAGE ZARA1st FLOOR, 2345561 and NOT 2021565267, 1MALL1ETAGE ZARA1st FLOOR, 2345561

To this end, you can use the following that makes use of regular expression to capture the first and last group of numbers:
import re

re.findall(&quot;^([0-9]+)(.*?)([0-9]+)$&quot;, &quot;2021565267MALL1ETAGE ZARA1st FLOOR 2345561&quot;)
# [('2021565267', 'MALL1ETAGE ZARA1st FLOOR ', '2345561')]

Applying strip() to each of the result removes the trailing whitespace to get the output you desire.