Hi to all,
Usual problem with the strings, which I cannot understand how to use.
i have a problem with string manipulation.
Actually, 2 problems.
1: Conversion of the date.
in my stream i collect the date from a web cloud, and upload file name, and date, to an sql table.
the date for convenience is a varchar value.
I have to save this date by removing all symbols, as in example. (“ddMMyyyy_hhmm”)
I can’t find a solution
Another small problem, again about text manipulation, is in the collection of the filename.
I noticed that my script fails when the “&” symbol is present in the object name on the Cloud.
When I save in the folder, the symbol will KO the BOT.
How do I replace the & with a - o.
@AaronMark - For your first problem here is the solution using Invoke code method…I guess it should HHmm in your conversion so that it will be in 24 hrs format.