Focal Point
[CLOSED] Datamigrator

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/5457004076

April 30, 2014, 04:26 PM
ray_In_Vancouver
[CLOSED] Datamigrator
!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>,


IWay SM 5.6, 6.01, 6.1, 6.9, 7.0
EDI, XML, XSD, WF 8.0, DM 77,8.0 asp.net, SQL Server
May 01, 2014, 12:01 PM
Clif
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