I am trying to build an internal office solution with UIPath that requires me to change the parameters below into variables.
I don’t know how to convert the day, month, and year in the string below into variables without getting an error.
I would love some help on getting it done, and an understanding of why I am finding it hard to figure out.
Here is the task:
I have defined two variables:
filename = “C:\Users\YINKA\Downloads\Bp_08_19_2020.csv”
sheetname = “Bp_08_19_2020”
As you can see, they are both dates. How do I make the dates variable so that when I conduct the exercise on 08/29/2020, these variables are renamed to 08_29_2020 or any date I choose to run the program?
Thank you very much gurus @Steven_Mckeering! and @Manish540. I have used your ideas and contributions to shorten my program. It works pretty good, but I am still stuck at the point where I have to
get UIPath to understand that “‘C:\Users\YINKA\Downloads'+sheetname+’.csv’” refers to the changing filename. It does not understand that. So I am probably not concatenating right, most likely.
Thank you very much gurus @Steven_Mckeering! and @Manish540. I have used your ideas and contributions to greatly shorten my program. It works pretty good, but I am still stuck at the point where I have to get UIPath to understand that “‘C:\Users\YINKA\Downloads'+sheetname+’.csv’” refers to the changing filename. It does not understand that. So I am probably not concatenating right, most likely.
@anandji05 Shukriya. I tried that. But when I do that it names the workbook “Downloads” and places it in a different folder entirely. This is not what I need. I need it to go to the Downloads folder and retrieve a workbook named “Bp_08_30_2020 .csv”
The sheet’s name changes everyday.
@Steven_McKeering, @anandji05, @Manish540 I tried that, it didn’t work.
Maybe I should shed more light:
Problem statement: I made a robot program that goes to an online database and downloads an excel sheet containing health data. It downloads the file to my downloads folder and names it Bp_08_30_2020.csv.
Inside the csv file, there is a worksheet already named 08_30_2020 from the online database. It is important to note that the filename changes every day to match with the current date.
So, let today’s date= ccdate = 08_30_2020
sheetname = Bp_08_30_2020
or to convert it to variable form, sheetname = “Bp_”+ccdate
therefore filename = ““C:\Users\YINKA\Downloads\Bp_”+ccdate+”.csv""
OR filename = ““C:\Users\YINKA\Downloads"+sheetname+”.csv”"
I don’t understand why it is not working.
Hi @anandji05. I tried both, but I get the errors shown in the attachments. It does not seem to add on the ccdate variable when naming the csv file, so the program fails.
Using the other option, it saves a file named Downloads inside an entirely different folder, because there is not slash after Download. Screenshots attached.
Why are you not using assignment activity for assigning variable.Put String variable in variable pan as default and take assignment activity for string manipulation.Main.xaml (4.6 KB)
Hi Anand! Your suggestion worked! Bakut Shukriya!
I wonder… why do we have to assign it to the variable before it works? Can’t we just create a variable and define the default value and get the same result? I find that a little confusing. Thanks again!
Anil_G
Ajay_Mishra
pravallikapaluri
postwick
AJ_Ask
Anonymouss
vignesh.maruthappan
mkankatala
mrohan.senapaty
ATHEEQ_UR-RAHMAN