<?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>Liber-T</stName>
  <stExtension>csv</stExtension>
  <oDateOrder>DMY</oDateOrder>
  <stDateDelimiter>/</stDateDelimiter>
  <bYear4Digits>true</bYear4Digits>
  <oFieldSeparator>PointVirgule</oFieldSeparator>
  <stDecimalSeparator>,</stDecimalSeparator>
  <stTimeSeparator>:</stTimeSeparator>
  <stTextSeparator />
  <bStartRow>true</bStartRow>
  <oListOfColumns>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCDateValue</FormatColumn>
    <FormatColumn>TCNote</FormatColumn>
    <FormatColumn>TCThirdParty</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCOther</FormatColumn>
    <FormatColumn>TCAmount</FormatColumn>
  </oListOfColumns>
  <strListOfRules>
    <FormatRule>
      <stDescription>Règles communes</stDescription>
      <bFromServer>false</bFromServer>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCNote</oFieldSource>
          <oAction>FieldConcatBelow</oAction>
          <oResultColumn>TCThirdParty</oResultColumn>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>FieldDelete</oAction>
          <oResultColumn />
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCAmount</oFieldSource>
          <oAction>ApplyRegex</oAction>
          <oResultColumn />
          <stResultText>(\d+\,\d{2}).+~-$1</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Transport</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCSubCategory</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Péage</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCMarker</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Verso</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCKind</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>Prélèvement</stResultText>
        </FormatRuleAction>
        <FormatRuleAction>
          <oFieldSource>TCDateReal</oFieldSource>
          <oAction>FieldReplace</oAction>
          <oResultColumn>TCDateValue</oResultColumn>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>COFIROUTE</stDescription>
      <bFromServer>false</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>{ANCENIS|VEIGNE|RESTIGNE}</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>COFIROUTE</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>ASF</stDescription>
      <bFromServer>false</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>.*{CORZE|ARTIERE}.*</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>ASF</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
    <FormatRule>
      <stDescription>APRR</stDescription>
      <bFromServer>false</bFromServer>
      <strListOfConditions>
        <FormatItemCondition>
          <oFieldReference>TCNote</oFieldReference>
          <oOperator>RegexIsTrue</oOperator>
          <oValueColumn />
          <stValueText>.*{GERZAT|QUINCIEUX}.*</stValueText>
        </FormatItemCondition>
      </strListOfConditions>
      <strListOfActions>
        <FormatRuleAction>
          <oFieldSource>TCThirdParty</oFieldSource>
          <oAction>StringReplace</oAction>
          <oResultColumn />
          <stResultText>APRR</stResultText>
        </FormatRuleAction>
      </strListOfActions>
    </FormatRule>
  </strListOfRules>
</FormatImport>