I did some testing on this a while back and this is what I found.
The file needs to use UTF-8 encoding. Values can be enclosed in double quotes - they will be stripped out when the file is imported.
Line Delimiter: can be semicolon, pipe, comma or tab (; | , TAB)
Field 1: Source Value
Field 2: Target Value
Field 3: Rule name/Map name. Blank for One-to-One/Explicit type maps
Field 4: Description. NOTE: can contain the delimiter if the Description is enclosed within double quotes
Field 5: OPTIONAL: Sort Order/Sequence. Defaults to 0
Flip Sign: If the Target Value begins with - (minus sign), the value is set to TRUE.
Special characters in the source value control the map types (if there are no special characters the map type is set to One-to-One):
| Characters | Map type | Example |
|---|---|---|
| > | Range | 100>199 |
| ~ | Range | 100~199 |
| , | List | 100,199 |
| ? | Mask | 10? |
| * | Mask | 10* |
| &&_ | List | &&_41137;41138 |
| ##_ | Composite | ##_E#[Dallas*]:A#[99*] |
Example lines:
"101070","-20400",,"Short Term Borrowings",1
"106920","13800",,"Prepaid, Expenses & Accrued Income"
122015>122115,Bypass,z1220s,,
"1150*","11500",z1150s,"Interco. Receivable - Finance",
HTH
