Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Microsoft Azure Data Lake Storage Gen2
  3. PowerExchange for Microsoft Azure Data Lake Storage Gen2 Configuration
  4. Microsoft Azure Data Lake Storage Gen2 Connections
  5. PowerExchange for Microsoft Azure Data Lake Storage Gen2 Data Objects
  6. Microsoft Azure Data Lake Storage Gen2 Mappings
  7. Appendix A: Microsoft Azure Data Lake Storage Gen2 Datatype Reference

PowerExchange for Microsoft Azure Data Lake Storage Gen2 User Guide

PowerExchange for Microsoft Azure Data Lake Storage Gen2 User Guide

Wildcard Characters for Reading Data from Flat Files

Wildcard Characters for Reading Data from Flat Files

When you run a mapping in the native environment to read data from a flat file, you can use an asterisk (*) wildcard character to specify the source file name.
You can use the asterisk (*) wildcard to fetch all the files or only the files that match the name pattern. Specify the wildcard character in the following format:
abc*.txt abc.*
For example, if you specify
abc*.txt
, all the file names starting with the term
abc
and ending with the
.txt
file extension are read. If you specify
abc.*
, all the file names starting with the term
abc
are read regardless of the extension.
You cannot use the wildcard characters to specify folder names. For example,
{ "WildcardURIs": [ "multiread_wildcard/dir1*/", "multiread_wildcard/*/" ] }

0 COMMENTS

We’d like to hear from you!