foxer-logo
new version!
foxer-logo

ATC Browser Test

Advanced Table Conversion (ATC) is a powerful new feature designed exclusively for tables, with date and currency identification capabilities. With ATC in automatic detection, any date, number format and separators are correctly identified as long as they are consistent in the original source.

You can test ATC with any browser on the tables below, or by downloading fxr-foxer ATC demo tables.rtf

 

Sample 1 - Currency Row

 First Row is Currency. Numbers in British Convention. Foxer takes current values in memory. No warnings as long as Currency exist & provided with value by the Subscription.

GBP USD EUR
1,000.10 1,100.10 1,200.10
2,000.20 2,100.20 2,200.20
3,000.30 3,100.30 3,200.30
 

Sample 2 / Currency Column

 First Column is Currency / Row is Concept. Numbers in International Convention

  Amount A Amount B Amount C
EUR 1.000,10 1.100,10 1.200,10
AUD 2.000,20 2.100,20 2.200,20
CNY 3.000,30 3.100,30 3.200,30
 

Sample 3 / Plugin + Currency Row + DMY Date Column

 First row is Currency with Subscription identifier ( ECB ). Numbers are in ambigous format.
 File from 2018.01.27 is missing. You'll get 1 Warning.

ECB GBP AUD NOK
25/01/2018 100 110 120
26/01/2018 200 210 220
27/01/2018 300 310 320
 

Sample 4 / Plugin + Currency Row + MDY Date Column

 Similar to previous sample. File from 2018.01.27 also missing. Currency XYZ doesn't exist. You'll get 2 Warnings.

BCA INR USD XYZ
01-25-2018 100 110 120
01-26-2018 200 210 220
01-27-2018 300 310 320
 

Sample 5 / Plugin + Currency Row + YMD Date Column

 Similar to previous sample but date column is YMD format Date. No file is missing for BOC Subscription.

BOC AUD USD JPY
2018.01.25 100 110 120
2018.01.26 200 210 220
2018.01.27 300 310 320

 (*) YMD format requires year with all digits.

Sample 6 / Ambigous date format

As DMY, you'll get 2 Warnings. As MDY, none.

ECB GBP AUD NOK
06-05-2017 100 110 120
06-06-2017 200 210 220
06-07-2017 300 310 320
 

Sample 7 / Cross Table with Plugin specification

ECB GBP USD EUR
GBP 100 110 120
USD 200 210 220
EUR 300 310 320