I have TXT file with two columns
The first column in format yyyy-MM-dd hh:mm:ss and the second as number such as:
2019-09-30 08:44:10;13.68
2019-09-30 08:44:20;13.68
2019-09-30 08:44:30;13.68
2019-09-30 08:44:40;13.68
2019-09-30 08:44:50;13.68
How to paste/import this data to SciDavis table?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Grzegorz,
Since you have the data in a file, I guess it is better to import the file instead of do copy-paste.
- Go to File -> Import ASCII... (or type Ctrl + k)
- In the import dialog:
1° - uncheck the following checkboxes: Numeric data; simplify white spaces
2° - change the separator from "SPACE" to ";"
3° - select the desired file and click open
Your file will be imported to a new table, with date in the 1st column and the numbers in the other.
Now, you need only to adjust the column types according to your needs.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have TXT file with two columns
The first column in format yyyy-MM-dd hh:mm:ss and the second as number such as:
2019-09-30 08:44:10;13.68
2019-09-30 08:44:20;13.68
2019-09-30 08:44:30;13.68
2019-09-30 08:44:40;13.68
2019-09-30 08:44:50;13.68
How to paste/import this data to SciDavis table?
Hi Grzegorz,
Since you have the data in a file, I guess it is better to import the file instead of do copy-paste.
- Go to File -> Import ASCII... (or type Ctrl + k)
- In the import dialog:
1° - uncheck the following checkboxes: Numeric data; simplify white spaces
2° - change the separator from "SPACE" to ";"
3° - select the desired file and click open
Your file will be imported to a new table, with date in the 1st column and the numbers in the other.
Now, you need only to adjust the column types according to your needs.
Hi
Thank you, it works.