extract string including empty values from a plain text using python

Question

I have a string

a='S
LINC             SHORT LEGAL                                   TITLE NUMBER
0037 471 661     1720278;16;21                                 172 211 342

LEGAL DESCRIPTION
PLAN 1720278  
BLOCK 16  
LOT 21  
EXCEPTING THEREOUT ALL MINES AND MINERALS  

ESTATE: FEE SIMPLE  
ATS REFERENCE: 4;24;54;2;SW

MUNICIPALITY: CITY OF EDMONTON

REFERENCE NUMBER: 172 023 641 +71

---------------------------------------------------------------------------- 
----
                     REGISTERED OWNER(S)
REGISTRATION    DATE(DMY)  DOCUMENT TYPE      VALUE           CONSIDERATION
----------------------------------------------------------------------------- 
---

172 211 342    15/08/2017                      $610,000        CASH & MTGE'

Need to extract values below document type, value and consideration and output in an array like ['','$610,000','CASH & MTGE'] I tried using findall(r'(?<!\S)(?:[$]\S+|[^$\d]+)\b', a). But I could only get ['$610,000','CASH & MTGE'] and no value for document type since it is empty.

Surya Teja Karra · Accepted Answer · 2018-12-18 11:25:14Z

0

From what I understood, you would like to return an Array with the values $610,000 CASH & MTGE' from the string right?

Assuming the required string value would remain in the end, we can leverage the splitlines function. Then, use len(a)-1 to fetch the required string something like this:

>>> a='''S
LINC             SHORT LEGAL                                   TITLE NUMBER
0037 471 661     1720278;16;21                                 172 211 342

LEGAL DESCRIPTION
PLAN 1720278  
BLOCK 16  
LOT 21  
EXCEPTING THEREOUT ALL MINES AND MINERALS  

ESTATE: FEE SIMPLE  
ATS REFERENCE: 4;24;54;2;SW

MUNICIPALITY: CITY OF EDMONTON

REFERENCE NUMBER: 172 023 641 +71

---------------------------------------------------------------------------- 
----
                     REGISTERED OWNER(S)
REGISTRATION    DATE(DMY)  DOCUMENT TYPE      VALUE           CONSIDERATION
----------------------------------------------------------------------------- 
---

172 211 342    15/08/2017                      $610,000        CASH & MTGE'''

>>> b=a.splitlines()
>>> req_line = b[len(b)-1]
>>> print(req_line)

answered Dec 18, 2018 at 11:25

Surya Teja Karra

5511 gold badge7 silver badges20 bronze badges

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

3 Comments

User123 Over a year ago

The above solution prints entire row in the last line as string. Instead is it possible to just get only last 3 field values in an array. Please not if there is empty value for a field, it should also be included too.

Surya Teja Karra Over a year ago

Well we can call split() function without arguments on req_line to return an array of fields that have values however if you need the empty columns as well, we need to probe the array values for their supposed location, say, if 'CASH' column will exist at all times, we can check if index 1 on the array has len > 0 and so on.

User123 Over a year ago

Is there any way to get empty strings into an array provided the column has any empty values?

Collectives™ on Stack Overflow

extract string including empty values from a plain text using python

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related