activeviam / autopivot Goto Github PK

the line

FOO,BAR,"FOO,BAR,",TEST

should split as FOO <> BAR <> FOOBAR <> TEST.

Instead, it splits as
[FOO,BAR,"FOO,BAR,",TEST, null, null]

I think there is an error in the logic around double quotes that appear after a comma. when you do the following, it will think you are still within quotes if the character before the ending quote was a comma:

			if(c == 0 || sep == text.charAt(c-1)) {
				// Beginning of a new field, delimited by quotes
				withinQuotes = true;
			}
			// or else is it the end of a field?
			else if((c == text.length()-1) || (sep == text.charAt(c+1))) {
				if(!withinQuotes) {
					LOGGER.warning("Unexpected double quote character at the end of a field: " + text);
				}
				withinQuotes = false;
			}

This is incorrect however, as it is actually ending the withinQuotes

eg snl-messages, dashboard configuration is pre 4.1.8

I use mvn clean install

but it bug

[ERROR] Failed to execute goal on project autopivot: Could not resolve dependencies for project com.activeviam.sandbox:autopivot:jar:2.0.0-SNAPSHOT: The following artifacts could not be resolved: com.activeviam.activepivot:activepivot-server-spring:jar:5.8.3-jdk8, com.activeviam.activepivot:activepivot-test:jar:5.8.3-jdk8, com.activeviam.activeui:activeui:jar:4.2.11: Could not find artifact com.activeviam.activepivot:activepivot-server-spring:jar:5.8.3-jdk8 in central (https://repo.maven.apache.org/maven2) -> [Help 1]

It looks like the discoverFile doesn't handle BOM markers that come from windows, so you get things like the first column name will be "Book" instead of "Book".

you could do something like this at the start:
lines.get(0).replace("","")