kbss-cvut / aircraft-maintenance-planning-system

D2020+ project about Aircraft Mainenance Planning System.
GNU Lesser General Public License v3.0
0 stars 0 forks source link

Time analysis fail if quoting is used at the end of a cell value #188

Open blcham opened 1 year ago

blcham commented 1 year ago

Following line within time-analysis processing failed:

7216722 50102   BEGOSLIM    24.02.2021  08:00   24.02.2021  10:33   2.550000    MECH-LDG    HM_L5_L_A   M   6007328     20-360-00-01    24.02.2021  FINDING (NRC) TASKCARD 20-360-00-01 (1.0) / 20-360 LDG: DURING INSPECTION WAS FOUND DAMAGED SEAL "B"    PH-HSA/H-23 HMV7    73H 13.646575   05.02.2021  24.02.2021  05.02.2021  01.03.2021  5   24.02.2021  HSA/HM7-RWF23   PH-HSA  TAV

The error is due to cell value:

FINDING (NRC) TASKCARD 20-360-00-01 (1.0) / 20-360 LDG: DURING INSPECTION WAS FOUND DAMAGED SEAL "B"

As can be seen " is at the end of the cell value and thus InvalidQuotingTokenizer.java workaround does not work, see comment on this class.

/**
    * <p> This class is a custom implementation of the Tokenizer interface
    * that allows to parse CSV and TSV files with invalid quoting.
    * Any quotes not next to a delimiter or at the start/end of the line should be escaped.</p>

@Matthew-Kulich can u think of some simple solution how to solve it? I don't.