When reading a date column, it is possible to provide a `*` at the end of the format to cause it to discard an optional time section, if present, for example:
read "/example.csv" as T date: "yyyy-MM-dd*" with
This will treat a value such as 2023-06-29 10:24:35 as if it were just 2023-06-29. Without this trim option, attempting to read the value will fail and report an error.
Similarly, when reading a number column, it is possible to provide a `*` at the end of the format to cause it to discard up to three non-digit characters either at the start or the end of the number value. For example:
read "/example.csv" as T number: "1,000.0*" with
This will treat a value such as 10.00 USD as if it were just 10.00. Without this trim option, attempting to read the value will fail and report an error.
Thanks a lot for your contribution arkadir !
There's a slight mistake, the date format specifying should appear before the alias of the table. So the line should be this instead.
When reading a date column, it is possible to provide a `*` at the end of the format to cause it to discard an optional time section, if present, for example:
This will treat a value such as
2023-06-29 10:24:35as if it were just2023-06-29. Without this trim option, attempting to read the value will fail and report an error.Similarly, when reading a number column, it is possible to provide a `*` at the end of the format to cause it to discard up to three non-digit characters either at the start or the end of the number value. For example:
This will treat a value such as
10.00 USDas if it were just10.00. Without this trim option, attempting to read the value will fail and report an error.Thanks a lot for your contribution arkadir !
There's a slight mistake, the date format specifying should appear before the alias of the table. So the line should be this instead.
read "/example.csv" date: "yyyy-MM-dd*" as T with