Add separator character to a specific index of a string

KNIME Analytics Platform
1

I have these datetime example strings below:

9121991
9121986
9111986
4111992
981996
9/7/1988
10/12/1993
10//11//1955
9/02/1965
08/01/1986

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.

09/12/1991
09/12/1986
09/11/1986
04/11/1992
09/08/1996
09/07/1988
10/12/1993
10/11/1955
09/02/1965
08/01/1986

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.
~g

2

If there is a way to say 1211999 what is this 12/01/1999 or 01/21/1999 in other case no.

3

Beyond this ambiguous case…that at the moment is not present in my set of data… what would be the good workaround for format correctly the datetime string values?

4

I would say this must be 12/01/1999 as format is ddmmyyyy so 21 can not be on mm place but 1112000 can be both 01/11/2000 and 11/01/2000. There are couple of cases like that: 111, 112, 212, 211, 311.
Br,
Ivan

5

Yes, there could be some ambiguous cases but actually I was trying to figure out how to transform well the most unambiguous cases that are so much rows (I cannot handle them manually ). Also because I would expect to have really less rows for ambiguous cases, and in that case I could handle them as single case.