Move CSV file from download folder to another folder

[Vijay_R1 (Vijay R)]

Hi Folks,

Please help me with this issue, from download folder I want to move CSV file to the another folder.

Note: This is the file CSV name “Export-Shelfwise Inventory-_15112023154313” and in the file name you can see numeric number “15112023154313” this will change randomly on daily basis. common name is “Export-Shelfwise Inventory-”. based on common name I want to select the file and move to the another folder.

Can anyone pls help me on this issue.

Thanks in advance

[Shiva_Nikhil]

@Vijay_R1

directory.GetFiles("C:\Users\cogni\Downloads","Export-Shelfwise Inventory-_*.csv").toarray

can you try this once gives you output as array of string

below it use for each activity inside use move file activity

[AJ_Ask]

Hi @Vijay_R1

This code will give you the path of the latest CSV file in the specified folder. Use it in a assign activity. Replace your folder path variable with yourfolder_path variable

str_filepath = Directory.GetFiles(yourfolder_path, “*.csv”) _
.OrderByDescending(Function(d) New FileInfo(d).CreationTime) _
.FirstOrDefault()

[rikulsilva (Henrique Lima da Silva)]

@Vijay_R1

Export-Shelfwise Inventory-_15112023154313

Hi

You can use the For Each File in Folder Activity and provide the filter Export-Shelfwise Inventory-_*.csv:

[Krishna_Raj]

@Vijay_R1
you can achieve this task using the “Assign” activity,
“Directory.GetFiles” method, and “Move File” activity.

[Vijay_R1 (Vijay R)]

Hey @rikulsilva,

Thanks a lot, it works

[Vijay_R1 (Vijay R)]

Hi @Shiva_Nikhil , I got the result thanks a lot

[Vijay_R1 (Vijay R)]

Hey @AJ_Ask thanks a lot I got the result

[Vijay_R1 (Vijay R)]

Hey @Krishna_Raj Thanks a lot I got the result