Un relevé CFONB où le signe se cache dans le dernier chiffre

apiVersion: connectors.lumnik.io/v1kind: Connectormetadata:  name: scenario-cfonb-b  connector_type: csv-file  scopes: [treasury-b]spec:  transport:    kind: local    path: /tmp/lumnik-scenario/cfonb-bank-statement/b/*.txt   # the bank's CFONB 120 statements  parser:    lines: true                    # fixed width: 120 characters per record, no separator  after_process: none  mapping:    cell:      - regex-extract:             # every record: its code, then the account it is about          column: line          required: true          pattern: "^(\\d{2})(.{5}).{4}(.{5})(.{3})(\\d).(.{11})"          groups: { 1: record, 2: bank, 3: branch, 4: currency, 5: decimals, 6: account }      - regex-extract:             # 01 old balance, 04 movement, 07 new balance          column: line          pattern: "^0[147].{32}(.{6}).{8}(.{31}).{2}(.{7}).{2}(.{14})"          groups: { 1: op_date, 2: label, 3: entry_no, 4: amount_raw }      - regex-extract: { column: line, pattern: "^05.{43}(.{3})(.{70})", groups: { 1: qualifier, 2: info } }   # 05 complement      - regex-extract: { column: line, pattern: "^01.{32}(.{6})", groups: { 1: statement_date } }              # 01 opens a statement      - regex-extract: { column: line, pattern: "^04.{79}(.{7})", groups: { 1: movement } }                    # 04 is a movement      - clean: { columns: [label, info, entry_no], strip: true }      - kotlin: { script: hooks:cfonb-amount-b.kts }                   # the signed amount, from its last character      - parse-number: { column: amount }      - parse-date: { column: op_date, formats: ["ddMMyy"] }      - parse-date: { column: statement_date, formats: ["ddMMyy"] }      - fill-down: { columns: [statement_date] }                                        # the statement, on each of its records      - fill-down: { columns: [movement], reset-when: { column: record, in: ["01", "07"] } }   # the movement, on its 05 complements

// Operator-provided: a CFONB 120 amount. 13 digits, then one character holding the last digit and the sign —// "{" and A to I for 0 to 9 positive, "}" and J to R for 0 to 9 negative — scaled by the record's decimals.@Suppress("UNCHECKED_CAST")val cells = bindings["cells"] as MutableMap<String, Any?>val raw = (cells["amount_raw"] as String?).orEmpty()if (raw.length == 14) {    val positive = "{ABCDEFGHI".indexOf(raw.last())    val negative = "}JKLMNOPQR".indexOf(raw.last())    val digit = if (positive >= 0) positive else negative    if (digit >= 0) {        val scaled = (raw.dropLast(1) + digit).toBigDecimal().movePointLeft((cells["decimals"] as String).toInt())        cells["amount"] = (if (negative >= 0) scaled.negate() else scaled).toPlainString()    }}

kind: Entityname: statement_line_blabel: Ligne de relevédescription: "One record of a CFONB 120 bank statement: its code, its statement, the movement it belongs to, its amount."match: [line]scopes: [treasury-b]columns:  line: { label: "Enregistrement" }  record: { label: "Code" }  statement_date: { label: "Relevé du" }  account: { label: "Compte" }  movement: { label: "Mouvement" }  op_date: { label: "Date d'opération" }  label: { label: "Libellé" }  qualifier: { label: "Qualifiant" }  info: { label: "Complément" }  amount: { label: "Montant" }sources:  - table: t_scenario_cfonb_b    map: { line: line, record: record, statement_date: statement_date, account: account, movement: movement, op_date: op_date,           label: label, qualifier: qualifier, info: info, amount: amount }