Using asLineChart plugin
Quote from saeid on May 29, 2021, 9:32 amHi,
I'm using asLineChart plugin to plot a figure in my software. I want to read the X and Y data from a .csv file. In order to use the asLineChart plugin, the data should be separated by the sign "|".
How can I store the data of a line of a .csv file in a variable and separate them by "|" character?
Hi,
I'm using asLineChart plugin to plot a figure in my software. I want to read the X and Y data from a .csv file. In order to use the asLineChart plugin, the data should be separated by the sign "|".
How can I store the data of a line of a .csv file in a variable and separate them by "|" character?
Quote from Gaev on May 29, 2021, 1:45 pm@saeid
How can I store the data of a line of a .csv file in a variable and separate them by | character?
I have not used asLineChart; so I am not familiar with the exact format of the expected data. Also, I am not sure how your csv data is formatted.
Perhaps you can post a few mockup lines of both, your csv data lines and the data expected by asLineChart.
How can I store the data of a line of a .csv file in a variable and separate them by | character?
I have not used asLineChart; so I am not familiar with the exact format of the expected data. Also, I am not sure how your csv data is formatted.
Perhaps you can post a few mockup lines of both, your csv data lines and the data expected by asLineChart.
Quote from Vadim on May 29, 2021, 8:56 pm@saeid
You can use the special character [#124] to write the vertical bar.
You can use the StrReplace command to replace the delimiter in the CSV file.
You can use the special character [#124] to write the vertical bar.
You can use the StrReplace command to replace the delimiter in the CSV file.
Quote from HPW on May 30, 2021, 7:24 amHello,
Use "FileLen" to get the number of lines.
Use "Fileread" in a loop to read each line.
Use "StrReplace" to replace the csv delimiter with your wanted | char.
Save each line string in an array.
Regards
Hello,
Use "FileLen" to get the number of lines.
Use "Fileread" in a loop to read each line.
Use "StrReplace" to replace the csv delimiter with your wanted | char.
Save each line string in an array.
Regards
Quote from HPW on May 30, 2021, 8:01 amHello,
By the way: When your csv fies has a header line with column names, your loop has to start with line 2 !
And looping filelen-1 !
Regards
Hans-Peter
Hello,
By the way: When your csv fies has a header line with column names, your loop has to start with line 2 !
And looping filelen-1 !
Regards
Hans-Peter