SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

In DataFlux I need to get the names of files in a directory.

Reply
Occasional Contributor
Posts: 11

In DataFlux I need to get the names of files in a directory.

Once I get the file names I will copy them to a different file name. See attached screen prints. How can I get this to work? Or do I do something else?   I get return code od -103.   Thank You

 

 

 

Super User
Posts: 7,757

Re: In DataFlux I need to get the names of files in a directory.

Posted in reply to MikeToole

Please post codes, example data and results in text form. Office files from the web are dangerous and therefore blocked for many members by security policies.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 11

Re: In DataFlux I need to get the names of files in a directory.

Posted in reply to KurtBremser

Here is my ELL     

nExecuteStatus = execute("/bin/ls", "C:\dataflux\INPUT\arcadia")

 

 

nExecuteStatus returns a -103  when I preview the Expression Node

Occasional Contributor
Posts: 11

Re: In DataFlux I need to get the names of files in a directory.

Posted in reply to KurtBremser

anyone know how to do this using regex in the epression node?

Ask a Question
Discussion stats
  • 3 replies
  • 163 views
  • 0 likes
  • 2 in conversation