Date Formats

A word of wartning if you use very wide format masks, as it now appears you require…

Because you have so many different formats, this could lead to undesirable future behaviour with the String to Date&Time config, where it becomes overly wide every time you open it. This is because it widens the config to the size of any large recently used format mask.

See the following topic (and subsequent replies) for more details:

You may be advised to use more than one node, and have each handle some of the formats, (with fail on error turned off) and then merge the resultant appended columns into a single column using Column Merger.

2 Likes