Dynamic data import / export


simply more productive
Up to 100,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.
  • Page:
  • 1

TOPIC: Row count

Row count 5 years 4 weeks ago #2246

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 25
i was wandering if is it possible:

- to count the total number of rows of a text file on the read side
and then
- to use the result (total number) as output to a filed on the write side

any suggestions?

thanks in advance

Please Log in or Create an account to join the conversation.

Re:Row count 5 years 4 weeks ago #2247

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 274
Hi Genaro,

Yes, it is! If you want to add the line count to each row you have to use the power of the .NET Heater and the following little script. In the attachment you’ll find an example.
int rows = -1;

public object DoWork()
  // only read the input file one time
  if (rows < 0)
    // Getting the READ Adapter
    TextFileAdapter adapter = (TextFileAdapter)AdapterRead;

    // Read all lines
    string [] lines = File.ReadAllLines(adapter.Filename);

    // adopt the line count
    rows = lines.Length;

  return rows;

If you want to add the line count to a Header/Footer row you can find an example here. Processing of CSV header and footer rows

Attachment counting_rows.zip not found


Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.082 seconds