FM substitution files

 

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