file pattern matching variables with regex

Question

I'm having a lot of trouble figuring out how to figure out this file pattern. I have the following code:

def file_pattern_match(self, fundCode, startDate, endDate):

    # check if the fundcode is in the array or if the fundcode matches one in the array
    fundCode = fundCode if fundCode in self.fundCodes else 'Invalid_Fund_Code'

    # set a file pattern
    file_pattern = 'unmapped_{fund}_{start}_{end}.csv'.format(fund=fundCode, start=startDate, end=endDate) 

    # look in the unmappedDir and see if there's a file with that name

    # if the there is load the positions
    pass

This is a funciton that's part of a class. There's one issue. I just realized that the parameter fundCode will actually be an array of values, so I need to use some sort of delimiter. In the end, I want to look for files matching this kind of pattern:

unmapped_FUND1_FUND2_FUNDETC_20180203_20180204.CSV or

unmapped_FUND1_20180203_20180204.CSV

I'm guessing regex would be a good use for this?

xyzjayne · Accepted Answer · 2018-07-06 15:21:45Z

1

You could try join.

fundCode_raw = ['FUND1','FUND2','FUNDETC']
fundCode_str = '_'.join(fundCode_raw)

>> fundCode_str
'FUND1_FUND2_FUNDETC'

answered Jul 6, 2018 at 15:21

xyzjayne

1,38711 silver badges25 bronze badges

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

Comments

GotCubes · Accepted Answer · 2018-07-06 16:02:57Z

0

You shouldn't need regex just to see if a file with that name exists. You can just construct the name of the file you're looking for (with the appropriate path), and then test to see if it exists.

import os
path = "unmappedDir/unmapped_{fund}_{start}_{end}.csv".format(fund = "_".join(fundCode), start = startDate, end = endDate)
if os.path.isfile(path):
    # Do loading.

answered Jul 6, 2018 at 16:02

GotCubes

944 bronze badges

Collectives™ on Stack Overflow

file pattern matching variables with regex

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related