How to read and write files in Spectrum.

Product Feature: Read From File

 

Queries

How to read all csv files from folder in Spectrum?

How to copy files from one folder to another folder?


1) For reading multiple files from directory

Wild Card naming is supported Spectrum 9.0 SP1 onwards.
[Example]
    To read all csv files in folder c:\sample. 

[Solution]
   Specify path as c:\sample\*.csv. 
 

2) For moving files from folder to another folder, you have to write script.

Note:

  • Each file must have the same layout (the same fields in the same positions).
  • Any record that does not match the layout specified on the Fields tab will be treated as a malformed record.
UPDATED:  October 23, 2017