Delimit the string from the text column in adf data flow

Question

Hi All,

Please help me out here! I'm trying to delimit the string to extract the date from the text column

Here is my value = "x-x-x-2021-12-13.json" trying to get only date value from the text.

Note: Need data flow expression because i'm doing this in data flow adf

Please help me out with the adf expression

Thanks in advance!

Answer 1

Is that a time that is at the start of the filename and you want to strip it off or is it something else? To convert a string to a date then you can use the toDate function in an expression.

   toDate(filename)  

Note that there is no just date type so all your values are going to include a time. If you need to filter out time for display/comparison/etc purposes then you can do that at the point you need to exclude them.

   toString(myDate, 'yyyy-MM-dd')  

If the filename has other stuff in front then you might first need to use regexExtract to capture just the date portion and then use toDate to convert it to a datetime value.

   toDate(regexExtract(filename, '[0-9]{4}-[0-9]{2}-[0-9]{2}\.json$'), 'yyyy-MM-dd')  

Just guessing a little on the RE. [0-9] matches a digit. {4} says there should be 4. $ says end of string. If your dates use single and double digit months/days then the expression needs to adjust a little.

Answer 2

Hi @Venkatesh Srinivasan ,

Thank you for posting query in Microsoft Q&A Platform.

You can use below expression data flows. Kindly check.
toDate(split(replace(myValue,'x-x-x-',''),'.')[0],'yyyy-MM-dd')

Hope this will help. Please let us know if any further queries.

------------

Please consider hitting Accept Answer button. Accepted answers helps community as well.