Python: filename matching using regex

Question

I have written this code

import os
from datetime import datetime
import re

now = datetime.now() 
filename = now.strftime("%Y%m%d%H%M") #For example 202006191839

for fname in os.listdir(downloadPath):                
   if re.match('export_' + filename + '[0-9]{2}.xlsx', fname):
      print(fname)

In downloadPath I have these files

export_20200619183900.xlsx
export_20200619183921.xlsx
export_20200619183930.xlsx

But the re.match is not matching as desired.

But, if i change

filename = now.strftime("%Y%m%d%H%M")

with a simple assignment

filename = "202006191839"

The code works. The problem is, I need to have dynamic data.

Can anyone help me?

Errrr, datetime.now() gives your current, local time. Are you sure you have a file with this timestamp? It will change every time you run your script. — bavaza
– bavaza, Commented Jun 19, 2020 at 16:53
Yes, the file is download in the same procedure, a few seconds earlier. — SirLancillotto
– SirLancillotto, Commented Jun 19, 2020 at 17:08

ekl1pse · Accepted Answer · 2020-06-19 16:58:08Z

1

I think it is because you are matching 'export_' + filename, but you said the file was excel_20200619183900

answered Jun 19, 2020 at 16:58

ekl1pse

6441 gold badge9 silver badges20 bronze badges

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

1 Comment

SirLancillotto Over a year ago

No no, I am sorry, the file is export_xxxxxxxx. I was wrong to write in the post!

SirLancillotto · Accepted Answer · 2020-07-03 07:30:09Z

0

Ok.

I am solved the problem... i am blind probably The file I search, is download before the above code, despite being very small, the search command starts before the download... I have add a simple time.sleep(2) before search command.

Thanks to all.

answered Jul 3, 2020 at 7:30

SirLancillotto

491 silver badge10 bronze badges

Collectives™ on Stack Overflow

Python: filename matching using regex

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related