Re: How to add a current date as suffix while usin...

databicky · ‎01-07-2023

how to add a current date after filename suffix while copy from the dbutils like report20221223.xlsx

dbutils.fs.cp('dbfs://temp/balancing/report.xlsx','abfss://con@adls/provsn/result/report.xlsx',True)

i need to add the current date in the file like report20220123.xlsx while copying from source to target location

how can we add a current date after the suffix in filename while using dbutils.

Aviral-Bhardwaj · ‎01-07-2023

This will give you a little bit more idea

import time
 
timestr = time.strftime("%Y%m%d-%H%M%S")
 
print(timestr)

Now you can use formator and implement this solution

Thanks

Aviral

AviralBhardwaj

Chaitanya_Raju · ‎01-07-2023

@Mohammed sadamusean hope the below code might help you,

from datetime import datetime
date_value = datetime.now().strftime("%Y%m%d")
 
src = 'dbfs:/FileStore/Test/File.csv'
trgt = f'dbfs:/FileStore/Test/File_{date_value}.csv' 
 
dbutils.fs.cp(src,trgt)

Happy Learning!!

Thanks for reading and like if this is useful and for improvements or feedback please comment.

View solution in original post

databicky · ‎01-10-2023

how can we get the data without hyphen

Chaitanya_Raju · ‎01-10-2023

You can try like below

from datetime import datetime
datevalue = datetime.now().strftime("%Y%m%d")
 
src = 'dbfs:/FileStore/Test/File.csv'
trgt = f'dbfs:/FileStore/Test/File{datevalue}.csv' 
 
dbutils.fs.cp(src,trgt)

Happy Learning!!

Thanks for reading and like if this is useful and for improvements or feedback please comment.

How to add a current date as suffix while using copy?