05-18-2020 04:27 AM
Hi
I have a .csv file. i want to read this csv file and want to display only 2 column elements in a for loop and i don't want to display first two element of 2nd column(only from third to last).
Note:no. of row and column may change.
05-18-2020 05:11 AM - edited 05-18-2020 05:15 AM
Hi Risuraj,
@Risuraj wrote:
Hi
I have a .csv file. i want to read this csv file and want to display only 2 column elements in a for loop and i don't want to display first two element of 2nd column(only from third to last).
Note:no. of row and column may change.
To read a CSV file you can use ReadDelimitedSpreadsheetFile.
Then use ArraySubset (or IndexArray) to get your 2 columns of interest.
Then use IndexArray to get the "2nd column" and ArraySubset to get all elements "from third to last"…
What have you tried so far? Where are you stuck? Do you get any errors?
05-18-2020 05:14 AM
05-18-2020 05:41 AM
Hi,
i have done till this point.i want to proceed in this way.
05-18-2020 05:56 AM - edited 05-18-2020 05:56 AM
Give this a try. I am using Array Subset to remove the first 2 rows. After that, you can autoindex the array and it will index on your rows.