How to write regex expression for particular format

Help Studio
, ,
1

hi , how to write a regex expression for below format.
2023-05-02_1269202_MembersListReport.xlsx
“YYYY-MM-DD_MemberGroupID_FileName.xlsx”
Here in this format only filename is fixed and file should be in xlsx fomat

2

Hi @Neha_Aggarwal1

If you want the file name you can use the below expression.
Store the file path in a variable called file path

- Assign -> Filename = Path.GetFilename(file path)

Hope it helps!!

3

Hi @Neha_Aggarwal1

image
image973×355 15.3 KB

Hope it helps!!

4

Hi,

\d{4}-\d{2}-\d{2}_\d{7}_MembersListReport.xlsx

Thank you

5

@Neha_Aggarwal1
Try this one:

image
image943×309 28.7 KB

6

Hi @Neha_Aggarwal1

image
image940×354 16.7 KB

Hope it helps!!

7

Hi @Neha_Aggarwal1

Try this

image
image945×426 59.7 KB

1 Like
8

“\d{4}-\d{2}-\d{2}\d+[A-Za-z]+.[xX][Ll][Ss][Xx]”

i am using this expression but it is working in below format also
“2023-05-02_1269202_MembersList.xlsx” As in this format Report is not mentioned in filename i,e after MembersList but also it is working fine not giving error.
i want this format 2023-05-02_1269202_MembersListReport.xlsx
“YYYY-MM-DD_MemberGroupID_FileName.xlsx”
Here in this format only filename is fixed and file should be in xlsx fomat

9

@Neha_Aggarwal1 Try this one:
Previous one was generic:

image
image933×402 29.6 KB

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.