PowerExchange for HDFS User Guide

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Wildcard Characters for Reading Data from Complex Files

When you run a mapping in the native environment or on the Spark engine to read data from complex files, you can use wildcard characters to specify the source directory name or the source file name. You can use wildcard characters to specify the absolute path or relative path.

To use wildcard characters for the source directory name or the source file name, select the

Allow Wildcard Characters

option in the advanced read properties of the complex file data object. You can then use wildcard characters in the

File path

field.

You can use the following wildcard characters:

? (Question mark): The question mark character (?) allows one occurrence of any character. For example, if you enter the source file name as
a?b.txt
, the Data Integration Service reads data from files with the following names:
a1b.txt

a2b.txt

aab.txt

acb.txt
* (Asterisk): The asterisk mark character (*) allows zero or more than one occurrence of any character. If you enter the source file name as
a*b.txt
, the Data Integration Service reads data from files with the following names:
aab.txt

a1b.txt

ab.txt

abc11b.txt
Combination of * (Asterisk) and ? (Question mark): The combination of asterisk mark character (*) and question mark character (?) allows zero or more than one occurrence of any character.

Rename Saved Search

Table of Contents

PowerExchange for HDFS User Guide

PowerExchange for HDFS User Guide

Wildcard Characters for Reading Data from Complex Files

Wildcard Characters for Reading Data from Complex Files