Hi,
I am trying to make the input typed in by someone to append to the beginning of a file.
Ie if a user types in 202211 the output file name will be 202211_test.xlsx , if its multiple dates, make it 202211_202212_test.xlsx
can this be done?
see attached workflow.
Solved! Go to Solution.
Hey @wonka1234, here's one way you could do it:
1) Add a bit of dummy text to your output file name that will be replaced on a real run (ABC here):
2) Add another Action tool to your Output Data, which replaces this 'ABC' with your list of dates - the nested Replace() is to swap commas for underscores so that if the user types '202211,202212', this becomes '202211_202212' as mentioned above:
3) Now if I run this:
Hope this helps? Let us know if not!
@wonka1234 just apply the same principle again - set up your Output to be something like ‘ABC_XYZ_test.xlsx’. The first Text Box input that we dealt with earlier, set that up to change the ‘ABC’ part, and then set up the second (name) filter to replace the ‘XYZ’.
User | Count |
---|---|
29 | |
27 | |
17 | |
14 | |
6 |