I have these datetime example strings below:
Basically I would like to format in this way, by adding the “/” character for divide day/month/year and 0 as first character for day or for month only when the index size it’s just 1… for example for number from 1 to 9 for day and for month I should expect 01…09.
The first thing that I thought was to filter-out the correct row value by using the length() function, since the correct datetime string values have 10 characters as length.
Then it would be easier to handle the just the incorrect values I supposed.
Is there a way to perform this sort of operation with string manipulation node?
Maybe by using the indexOf() function and a replace() function?
Thanks in advance.