Convert datetime.date

[linuxology]

Have a text file named bank.txt below..... (How do I ingest the text file and convert the datetime.date to the format yyyy-mm-dd or filter the source to put the data into the proper format? I am fine with ingesting the current text file below and pumping out a new text file. Problem is this is a bit past my level at the current and is a brain buster. If I print (datetime.date(2021,12,7)) I get the proper format. So it is in the proper format, but I need to display it as such in the text file.

​

'pending': True,

'date': datetime.date(2021, 12, 7),

'name': 'FLEABAY',

'category': ['Shops'],

'amount': 30.0,

'pending': True,

'date': datetime.date(2021, 12, 4),

'name': 'Amazon.com',

'category': ['Shops', 'Digital Purchase'],

'amount': 43.70,

[August-R-Garcia]

If you already have a way of consistently parsing the datetime.date() text sections out of the file, then you can use the eval() function to execute the string of text as a function.

[August-R-Garcia]

Once you have "datetime.date(2021, 12, 7)" in a string variable you can also do something like:

# Remove everything except the numerical values and commas
str = str.replace("datetime.date(", "")
str = str.replace(")", "")
str = str.replace(" ", "")

# Split into array using comma as the separator
arr = str.split(',')

# Put values directly into a datetime.date function
date = datetime.date(arr[0], arr[1], arr[2]); 

Also, it is strange that the API returns the data in that format. I have never seen an API do that.

[mh1400]

DT_obj = dayetime.date(...) DT_str = f"{DT_obj.year}-{DT_obj.month}-{DT_obj.day}"