Issue with python code in dataframe

Question

File name is cdr-1725341100483.csv. Requirement is to fetch 13 digit code from filename and convert into date using epoch date.

below code is able to fetch 13 digit . but unable to convert to date.

"file_date",

          from_unixtime(

            (split(split(col("file_name"), "-").getItem(-1), ".").getItem(0).cast("int")/1000).cast("long")

         ).cast("date")

Answer 1

Hi Shubham Garg,

Thank you for reaching out to us on the Microsoft Q&A forum.

This topic is currently not supported in the Q&A forums. 

We recommend posting your query in the dedicated Microsoft Fabric Community Forum under the General Discussion section. Experts and moderators are available there to provide assistance and guidance. You can access the community here.

I hope this information is helpful. If it is, please click Accept Answer and Upvote to assist other community members.