This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
In ADF copy activity source I have created a dataset to look at .csv file at source.
The format of the source file names are for example:
abc-15 february 2024
abc-14 jan 2024
...
notice the date month can be either long or short.
How can I cater for this month change format in the expression?
At present my expression is like this:
@concat('abc-',formatDateTime(dataset().p_CurrentDate,'dd'), '-',formatDateTime(dataset().p_CurrentDate,'MMM'),'-',formatDateTime(dataset().p_CurrentDate,'yyyy'),'.csv')
Do you mean to say that the file can be either in this format abc-15 february 2024 or below format abc-14 jan 2024 ?
If that is the case you can use get meta data activity to check whether the file exists with either of 2 formats and proceed in the flow where it exists
I see. ok, I addeded a getmeta data activity. how do I check in this activity for two different date formats?
note that I use a copy activity to pull the file from a website first thank you
Can you please provide the screenshot of your overall flow?
That would help us help you better.
You mean you have a copy activity that extracts data from website into a file or downlads a file from web site? And the file name is not always in same format and may vary across the 2 stated by you? Is my understanding correct ?
And what is it that you want to do post the copy activity?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
arkiboys Did you consider using any if condition checking length of p_CurrentDate? something like the below sample expression/
Note: Capture the Lengths of dataset().p_CurrentDate into a Variable first.
Below expression is just an idea to take decision on the length basis... Please try and do let us know...
thank you
solved and thank you
@arkiboys If the response is helpful, please click "Accept Answer", we can close the case.
wrong post