File content format string definition
- Last UpdatedApr 24, 2025
- 2 minute read
A format string consists of codes contained within curly braces to indicate which fields to import or export. Each code is contained in its own set of braces.
For exports, any text not contained within a set of curly braces is treated as static text and included in the exported record verbatim. The table below shows the available codes and their definitions.
Note: A number can be included along with the code inside a set of curly braces to indicate that the field is to have a fixed width in the file.
|
Code |
Definition |
|---|---|
|
t |
Tag – {t} or {t32}. |
|
v |
Value – {v} or {vn.d}. Where:
|
|
d |
Date:
|
|
s |
Status – {s} or {s12}. |
|
b |
Binary Text – {b} or {b10}. |
|
x |
Description – {x} or {x50}. |
|
a |
Area – {a} or {a20}. |
|
u |
Group – {u} or {u20}. |
|
m |
Meter Number – {m} or {m10}. |
|
i |
Ignore (for import only) – {i25} = ignore 25 spaces. |
Examples
The table below shows the resulting output of several format strings entered into the Format field of the ImportExportConfig Row Edit dialog box.
|
Format String |
Output |
|---|---|
|
{t},{v6.2},{d},{s} |
SAGVLT, 76.23,4/15/2003 18:36:42,NORMAL |
|
Tag:{t}, Value:{v} |
Tag:SAGVLT, Value:76.232 |
|
{t16}/{v}/{b8} |
SAGVLT /1.0/On |