To level set, no CIS degree or programming/developer experience outside of starting UiPath a few months ago.
I have a process were I managed to get what I wanted accomplished, but I’m sure it could be done with far less steps. I was just hoping for some insight/feedback/resources to skill up in the area.
Scenario: There’s SQL file with coding & notes. The notes need to be parsed out. One of the dates needs to be updated to the current week’s Wednesday when the job runs on Thursday. The SQL code then needs to be pasted into another application an run.
Below is a screenshot of the workflow that I ultimately built:
Read File Text output = SQLcode
TrimmedSQL = SQLcode.Split("*"c )(0).ToString.Trim
Wednesday = DateTime.Now.AddDays(-1*(7 + (DateTime.Now.DayOfWeek - DayOfWeek .Wednesday)) mod 7).Date
strWednesday = Wednesday.ToString(“yyyy-MM-dd”)
LastWeek = Wednesday.AddDays(-7)
strLastWeek = LastWeek.ToString(“yyyy-MM-dd”)
Replace overwrites strLastWeek with strWednesday