| ... | ... | @@ -7,14 +7,17 @@ A CSV Parser is responsible to read your CSV-files correctly. Later you will nee |
|
|
|
In the following we will have a look at the fields which need to be filled out, when creating a parser:
|
|
|
|
|
|
|
|
* **Project:** The parser will only be available for users within this project
|
|
|
|
* **Timestamp format**: The expected format follows https://strftime.org/ (also see interactive https://www.strfti.me/)
|
|
|
|
* **Timestamp format**: The expected format follows https://strftime.org/ (also see interactive https://www.strfti.me/) [with some minor exeptions - see Example 3]
|
|
|
|
* Example 1:
|
|
|
|
* If your timestamp looks like this `6/13/2024 3:45:00 PM`
|
|
|
|
* The Timestamp format is : `%m/%d/%Y %I:%M:%S %p`
|
|
|
|
* Example 2:
|
|
|
|
* `"2025-02-10 00:15:30"`
|
|
|
|
* `%Y-%m-%d %H:%M:%S`
|
|
|
|
* Note in this example, the quotationmarks `"` do not appear in the timestamp format.
|
|
|
|
* Timestamp as in file : `2025-02-10 00:15:30`
|
|
|
|
* Timestamp format :`%Y-%m-%d %H:%M:%S`
|
|
|
|
* Example 3:
|
|
|
|
* Timestamp as in file : `"2025-02-10 00:15:30"`
|
|
|
|
* Timestamp format : `%Y-%m-%d %H:%M:%S`
|
|
|
|
* Note in this example, that the quotationmarks `"` do not appear in the timestamp format.
|
|
|
|
* **Column delimiter:** e.g. typical csv delimiter: , ; \\t
|
|
|
|
* **Timestamp column(s)** :
|
|
|
|
* Note that the counter starts with zero.
|
| ... | ... | |
| ... | ... | |