Append Input Date to Output File name

[areeba]

Hi ,

Is it possible to take date from input file/source file and append it in the Output file ?

For eg:

Input File name is : 'Orange- Fruits and Vegetables(weekly) - Organic Farm Land 2020-09-30  _08_03 CEST.xlsx'

My output file name should be like this:  'Fruits Overview 2020-09-30'

Regards

Areeba

[atcodedog05]

Hi @areeba 

Here is a workflow for the task.

Output File:

Workflow:

Configure input tool to get filename

Output tool config:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[areeba]

Hi @atcodedog05 

Thank you for the solution ,this worked perfectly fine but i have one issue.

I have 3 folders :

FLOWS--- i keep all my workflows

INPUT----i keep all input files

OUTPUT---I keep all Output generated files.

 When i am selecting  'Change entire path' of output setting then my output is getting save with the correct expected file name  in the 'FLOWS' folder where i have  my all workflows, whereas  i am giving path of Output folder.

When i am selecting 'Change File/Table name'  then output is getting saved in OUTPUT  Folder(correct folder) but file name is Output.xlsx not the 'Fruits Overview 30-09-2020

and just one thing more. i need to print exactly like this  'Fruits Overview 09-2020' not Fruits overview 2020-09-30 . Sorry for the change.

Can you please suggest where i am going wrong ?

Regards

Areeba

[atcodedog05]

Hi @areeba 

Replace the highlighted text with output folder path

And filename has been changed as requested.

Please check and let me know.

[areeba]

Hi @atcodedog05 

It is getting saved now in correct folder but its printing just 'Fruits  Overview' only , not the month and year. ☹️

[atcodedog05]

Hi @areeba 

that is strange can you share me snapshot of your formula Tool.

And stay with me lets close this

[areeba]

@atcodedog05 

Here you go :

[atcodedog05]

Hi @areeba 

Is Date field Null or is it getting values?

It was working fine before right?

[areeba]

Hi @atcodedog05 

Date field is getting values '30-09-2020' and yeah it was working fine before .

[atcodedog05]

Hi @areeba 

I have a slight change and split the formula into

Can you try and run this see is dateformatted column getting populated