Dear all,
I’m struggeling with this topic:
I have a list (using for each to iterate through it), with strings (e.g. “OK_riskprofile_2907_Ledger_20180601_tm_20180630.xlsx”, “production_care_make__2018_05-07-2018.xlsx” ). Now it needs to match a value in a datatable. So within the for each I have a for each row. Now the hard part is, the row(0).tostring gives values such as:
“&outall.\OK_riskprofile&riskprofile.Ledger&Ledgerdate.tm&Ledgerdateend…xlsx”
“&outall.\production_care_make_S&Year._&DateToday…xlsx”
So I am searching for a method to use wildcards such as:
“OK_riskprofileLedgertm*.xlsx”
“&outall.\production_care_make_S_.xlsx”
Does anyone have an idea? Can i use ismatch or regex? Or do I need split and then iterate? How can I make that variable?
Cheers,
Rob