<?xml version="1.0" encoding="utf-8"?>
<FormatImport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <oKind>TransactionCurrent</oKind>
  <stName>Format ofx CA</stName>
  <stExtension>ofx</stExtension>
  <oDateOrder>YMD</oDateOrder>
  <stDateDelimiter />
  <bYear4Digits>true</bYear4Digits>
  <oFieldSeparator>PointVirgule</oFieldSeparator>
  <stDecimalSeparator>.</stDecimalSeparator>
  <stTimeSeparator>:</stTimeSeparator>
  <stTextSeparator>"</stTextSeparator>
  <bStartRow>false</bStartRow>
  <strListOfRules>
    <Rules>
      <stDescription>MEMO = PAIEMENT PAR CARTE</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Contains</oOperator>
          <oValueColumn />
          <stValueText>PAIEMENT PAR CARTE</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Carte bancaire</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>FieldAdd</oAction>
          <oResultColumn />
          <stResultText>&lt;Nom de votre carte&gt;</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(.*)PAIEMENT\sPAR\sCARTE(.*)~$1$2</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = RETRAIT AU DISTRIBUTEUR</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Contains</oOperator>
          <oValueColumn />
          <stValueText>RETRAIT AU DISTRIBUTEUR</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Retrait espèce par carte</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>FieldAdd</oAction>
          <oResultColumn />
          <stResultText>&lt;Nom de votre carte&gt;</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(.*)RETRAIT\sAU\sDISTRIBUTEUR(.*)~$1$2</stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = VIREMENT EN VOTRE FAVEUR</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Contains</oOperator>
          <oValueColumn />
          <stValueText>VIREMENT EN VOTRE FAVEUR</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Versement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(.*)VIREMENT\sEN\sVOTRE\sFAVEUR(.*)~$1$2</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = VIREMENT EMIS</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Contains</oOperator>
          <oValueColumn />
          <stValueText>VIREMENT EMIS</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Virement Intercomptes</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(.*)VIREMENT\sEMIS(.*)~$1$2</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = PRELEVEMENT</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Contains</oOperator>
          <oValueColumn />
          <stValueText>PRELEVEMENT</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(.*)PRELEVEMENT(.*)~$1$2</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = CHEQUE EMIS</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Contains</oOperator>
          <oValueColumn />
          <stValueText>CHEQUE EMIS</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Chèque émis</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = PRELEVMNT</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Contains</oOperator>
          <oValueColumn />
          <stValueText>PRELEVMNT</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(.*)PRELEVMNT(.*)~$1$2</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>NAME = PRELEVMNT</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>PRELEVMNT</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = VIREMENT EMIS</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Contains</oOperator>
          <oValueColumn />
          <stValueText>VIREMENT EMIS</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(.*)VIREMENT\sEMIS(.*)~$1$2</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>NAME = VIREMENT EMIS</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCThirdParty</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>VIREMENT EMIS</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = . tiers et FITID contient la Date de valeur des CB</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>StartsWith</oOperator>
          <oValueColumn />
          <stValueText>. </stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCDateValue</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCIdImport</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^([0-9]{4})([0-9]{2})([0-9]{2})[0-9]*~$1$2$3</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCDateValue</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCIdImport</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Carte bancaire</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>&lt;Nom de votre carte&gt;</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCNote</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>TrimStart</oAction>
          <oResultColumn />
          <stResultText>. </stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>MEMO = . uniquement et FITID contient la Date de valeur des CB</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>.</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCDateValue</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCIdImport</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>^([0-9]{4})([0-9]{2})([0-9]{2})[0-9]*~$1$2$3</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCDateValue</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCIdImport</oResultColumn>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Carte bancaire</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCB</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>&lt;Nom de votre carte&gt;</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Minuscule / Majuscule</stDescription>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>ToUpperFirstChar</oAction>
          <oResultColumn />
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCCheque</oFieldSource>
          <oAction>ToUpper</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Nettoyage des champs</stDescription>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>TrimEnd</oAction>
          <oResultColumn />
          <stResultText>0123456789 /</stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>TrimStart</oAction>
          <oResultColumn />
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>\s+~ </stResultText>
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>TrimEnd</oAction>
          <oResultColumn />
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>TrimStart</oAction>
          <oResultColumn />
        </RulesAction>
        <RulesAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>\s+~ </stResultText>
        </RulesAction>
      </strListOfActions>
    </Rules>
    <Rules>
      <stDescription>Purge des identifiants d'importation en doublon</stDescription>
      <strListOfConditions>
        <RulesCondition>
          <oFieldReference>TCIdImport</oFieldReference>
          <oOperator>Egal</oOperator>
          <oValueColumn />
          <stValueText>0000000000000</stValueText>
        </RulesCondition>
      </strListOfConditions>
      <strListOfActions>
        <RulesAction>
          <oFieldSource>TCIdImport</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </RulesAction>
      </strListOfActions>
    </Rules>
  </strListOfRules>
</FormatImport>