Data with mixed date format

[gogon]

Hello

I have multiple csv all same structure but for some reason some csv will have time format am/pm and others will have 24-hr format… Can anyone suggest how to manipulate so all format will be am/pm?

Thanks,

[Kathrin]

Hi @gogon,

welcome to the KNIME Community Forum

KNIME Analytics Platform has a special data type for date and time information. I would suggest to split your data set into two subsets using a Row Splitter node:

• Rows with am/pm format
• Rows with 24h format

Next, you can convert the string information into the date&time format using the String to Date&Time node and concatenate the two subset using a Concatenate node.

If you need your time information in string format you can also convert it back using the Date&Time to String node.

Here is a little workflow with the described steps

Unify different time formats – kathrin

Please let me in case of any further questions
Kathrin

[gogon]

thank you! I spent hours last night and did exactly what you wrote… the trick is splitting them up and do the time format separately