Commercial data sources and different interpreters can use a variety of different names for the same formation. For simplicity, it's sometimes useful to translate one or more formation names into a single, preferred name during import. A "formation substitution" file lists the preferred formation name followed by variations of that name. As an example, listing DSAND with the variant 602DKOTD will change all 602DKOTD to DSAND.
Any name not translated by the substitution file will remain as is. Some importers can use the substitution filter as a filter; formation tops not on the substitution file are skipped.
Substitution files are a simple text ASCII file, and can be created with a text editor like Notepad or Wordpad. The file consists of a list of preferred names followed by the variants of that name. Every line has a prefix of 1 or 2, where "1" represents the preferred name and 2 represents the variants.
1AAQP
200002
13675 SAND
20003675S
1ALMA & CROMWELL
2000AACL
1ANHYDRITE
2000ANDR
1ANHYDRITE 1
2000ANDR1
1ANHYDRITE STRINGER
2000ANDRS
A fm substitution file using IHS formation translations
Substitution files can also use the wildcard characters "*" and "?" to look for multiple variations of a name. Similar to DOS and Windows, the "*" can stand in for any number of characters, while the ? can only stand in for one character. As an example, ABC* will translate any name that begins with ABC to the preferred name, while ABC? will translate only 4-letter names starting with ABC.
1COTTON VALLEY
2BOSSIER
2C V*
2COTTON VALLEY*
1JACKSON
2CADDELL
2EOCENE
1WILCOX
2CARRIZO
2WILCOX*
1CLAIBORNE
2COCKFIELD
2QUEEN CITY
2SPARTA*
2YEGUA
A fm substitution file with wildcards
|