Question

How to extract year, month and day and prefix text from each strings in a list of strings with Python

Answer 1

import re
 
lst = ['JV20220117','XYZ20010703', 'QP20211027']
 
print(re.sub(r'(\w*)(\d{4})(\d{2})(\d{2})', r'text: \1, year: \2, month: \3, day: \4','\n'.join(lst)))
 


 
 
'''
run:
 
text: JV, year: 2022, month: 01, day: 17
text: XYZ, year: 2001, month: 07, day: 03
text: QP, year: 2021, month: 10, day: 27

'''

 

70+ SQL courses for beginners and professionals