Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Amazon S3
  3. PowerExchange for Amazon S3 Configuration Overview
  4. Amazon S3 Connections
  5. PowerExchange for Amazon S3 Data Objects
  6. PowerExchange for Amazon S3 Mappings
  7. Appendix A: Amazon S3 Data Type Reference
  8. Appendix B: Troubleshooting

PowerExchange for Amazon S3 User Guide

PowerExchange for Amazon S3 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, 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!