!findstr /R /N "^" d:\AwiFileOutput.csv | find /C ":"

This command is return the number of rows in a csv file.

need to capture it in a &&RowCnt variable to use in flow

This message has been edited. Last edited by: <Kathryn Henning>,

Is it possible to change the tile to somethign more relevant to your question than "Datamigrator?"

The problem is that the DOS command find doesn't return the number of rows; it returns a 0 or 1 whether it was found or not. It outputs the number of rows to the console. So you just need to re-direct the output and read in the value.

!findstr /R /N "^" &FNAME | find /C ":" >lines.txt
FILEDEF LINES DISK lines.txt 
-RUN
-READ LINES &COUNT.A2
-TYPE Count &COUNT