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(89.60000000000001, 73%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
I have file names in adls gen 2 container
With format domain_term_20200114.csv
I want to change the format of date
From 20200114 to 2020-01-14 for all files.
Can someone suggest how to achieve this using add dynamic content and expression language in azure.
An Azure service for ingesting, preparing, and transforming data at scale.
Hi @Rishi Patel ,
Just checking in to see if the below answers helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.
Answer accepted by question author
![](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(240, 12%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Hi@Rishi Patel , as it has been mentioned in below thread, we need to use the derived column , todate and coalesce function for this.
https://learn.microsoft.com/en-us/answers/questions/135485/azure-data-factory-date-conversion.html Thanks
The following thread suggests the use of data flow which is not required in this case as I do no want to create new column in the dataset, the only change required is in file name date format string.
Current file name format “domain_term_20200114.csv”
Required format.
“domain_term_2020-01-14.csv”
Then, this should help you.
https://azurelib.com/datetime-conversions-in-azure-data-factory/
Similarly using he expression @formatDateTime(utcnow(),'yyyy-mm-dd') should get you what you want. Thanks
Hey,
Please use the below expression :
@markus.bohland@hotmail.de (split(variables('Test'),'' )[0],'',split(variables('Test'),'' )[1],'',concat(substring(split(variables('Test'),'' )[2],0 , 4),'-',substring(split(variables('Test'),'' )[2],4 , 2),'-',substring(split(variables('Test'),'_' )[2],6 , 6)))
where the Test is a variable containing your file name
code:
{
"name": "pipeline1",
"properties": {
"activities": [
{
"name": "Set variable2",
"type": "SetVariable",
"dependsOn": [],
"userProperties": [],
"typeProperties": {
"variableName": "Final",
"value": {
"value": "@markus.bohland@hotmail.de (split(variables('Test'),'' )[0],'',split(variables('Test'),'' )[1],'',concat(substring(split(variables('Test'),'' )[2],0 , 4),'-',substring(split(variables('Test'),'' )[2],4 , 2),'-',substring(split(variables('Test'),'_' )[2],6 , 6)))",
"type": "Expression"
}
}
}
],
"variables": {
"Test": {
"type": "String",
"defaultValue": "domain_term_20200114.csv"
},
"Final": {
"type": "String"
}
},
"annotations": []
}
}