How to solve the problem of not reading after an empty row when using "read CSV" for CSV File!

Help Activities
2

Hello @jukim, here is a step-by-step guide to solve the problem and the UiPath project file is attached. If this step-by-step guide helped you solve the problem, please mark this issue as solved.

The behavior you are describing occurs because, by default, the “Read CSV” activity in UiPath interprets an empty line as the end of the data. To handle this and ensure that all lines are read, including those after an empty line, you can use an alternative approach.

  1. Use “Read Text” to load the CSV file into a string.
  2. Use “Assign” to split the lines:
    lines = text.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries)
  3. Re-merge the valid lines:
    textNoEmptyLines = String.Join(Environment.NewLine, lines)
  4. Use “Write Text” to save the text to a clean CSV file.
  5. Use “Read CSV” on the new file.
    Here is the UiPath project
    WorkflowCSV.zip (3.2 KB)