Error situation | Behavior |
Text -> date: Time format contains characters that are not indicated by quotation marks and are not available as date characters in the transferred language. | The operator returns no data. Error message |
Text -> date: Column contains non-empty strings that do not match the time format. | The incorrect cell remains empty in the target column. The data type change for the column is continued for the remaining rows. Warning message. |
Text -> date: Column contains empty cells | The incorrect row remains empty. The data type change for the column is continued for the remaining rows. Warning message. |
Text -> number: Column contains strings that cannot be directly interpreted as numbers, e.g., because they contain units. | Tolerance: All non-numerical characters are ignored and a numerical value is created from the rest. Exception: If, e, E, +e, +E, or -E is embedded in figures, they are interpreted as part of "computerized scientific notation" of the number and are not ignored. No message is output. Error: If the string is still not successfully changed, the affected cell remains empty. Warning message |
Number -> date: The source number has decimal places. | The number is rounded to a value without decimal places and the data type is changed using this value. |