String to DateTime strange parse error

Hello everyone,

I am getting a (for me) very strange error while parsing string to datetime.

Setup

My data comes from a .txt-Document, I use the File Reader Node to autodetect the format. Now I would like to parse the columns STARTDATE, COMPDATE and DUEDATE to Datetime-Type. The columns are formatted “MM/dd/yyyy HH:mm:ss”, which is also the way I configured the String to Date&Time-Node.

For better readability I only show one column in the example screenshots

File Reader

String to Date%Time

The Problem

When executing the Sting to Date&Time-Node I get a parsing-error.

Error Message

Taking a close look at the message it appears, that there is a leading-whitespace in the STARTDATE-Column. So I included a String Manipulation-Node to remove it as following:

String Manipulation

As per description the strip(x) command removes leading and trailing whitespaces. But the error-massage stays as is, still implying a leading whitespac.

At this point I don’t know what else to do? Looking at the File Reader I cant see any whitespaces in the first place. Any suggestions on how to resolve this?

Thank you very much in advance!