Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
blcham opened this issue Feb 25, 2023 · 0 comments
Open

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

blcham opened this issue Feb 25, 2023 · 0 comments

Comments

@blcham
Copy link
Contributor

blcham commented Feb 25, 2023

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant