For changing format of a datetime string would be to convert it to a datetime specifying the current format, and then converting that back to a string specifying the required format.
Just overtype the format in both dialogs if the format you want is not shown. Please note the format mask is case-sensitive, so enter it as shown above.
For String Concatenation, you can use String Manipulation:
As an alternative, if you find that some of your numbers already contain one or more zeroes and you wish them to universally on have a 00 prefix, you could use String Replacer instead,
and have it replace the following regex:
regex: ^(0*)([0-9]*)$
with this: 00$2
Depending on your version of KNIME, String Replacer config will look like this:
Hi takbb! Thank you so much! I did encounter one issue with the String to Date&Time step.
I’ve followed the entries but is getting this error: Execute failed: Failed to parse date in row 'Row0: Text ‘2023-11-06’ could not be parsed at index 10
Hi @arzconci , it looks like you have at least one row containing data in a different format. In this case it is just ‘2023-11-06’ without the expected time part.
It appears from the message to be on the first row (Row0) so you’d need to look at all those columns that are selected and see which is the offending column.
Alternatively, you could try changing the mask as follows,
to make the Time part optional :
