Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Datamigrator
 Login/Join
 
Gold member
posted
!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
 
Posts: 85 | Registered: February 27, 2009Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 379 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.