How to skip last 2 rows while reading a CSV file using commatext class .

(0) Share

Report

Posted on by Mav

Hi experts,

I have a code to read CSV file using Comma text IO class. It works fine , however i am unable to figure out how can i customize it so that it skips reading last 2 rows of the CSV file.

Please share psuedo/full code.

Thanks

Mav

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Sergei Minozhenko 23,093 on at

Like (1)

Report
Hi Mav,

If you use newline as row delimiter, you can calculate the number of lines with TextBuffer before you start reading the file with CommaTextIO. In the while loop for CommaTextIO you can increment current line and compare it with the total number of lines.

TextBuffer textBuffer = new TextBuffer(); textBuffer.fromFile("my_file_path"); info(strFmt("%1", textBuffer.numLines()));

docs.microsoft.com/.../textbuffer-class

Was this reply helpful? Yes No