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

Line breaks are not recognised on a Windows computer #1255

Open
tischi opened this issue Apr 29, 2024 · 1 comment
Open

Line breaks are not recognised on a Windows computer #1255

tischi opened this issue Apr 29, 2024 · 1 comment

Comments

@tischi
Copy link

tischi commented Apr 29, 2024

Hi,

We have a seemingly Windows specific issue, where the line breaks of the CSV are not recognised.

I am not sure how to debug this efficiently, because I do not have a Windows computer with a development environment.

Is there anything general I could try to make this more robust across OS?

This is my current code, which opens the tables correctly on a Mac:

final InputStream inputStream = IOHelper.getInputStream( path );
// https://jtablesaw.github.io/tablesaw/userguide/importing_data.html
CsvReadOptions.Builder builder = CsvReadOptions.builder( inputStream )
	.separator( separator )
	.missingValueIndicator( "na", "none", "nan" )
	.sample( numSamples > 0 )
	.sampleSize( numSamples )
	.columnTypesPartial( nameToType );
final Table rows = Table.read().usingOptions( builder );

And here is the table that creates the problems on Windows:

test-crop-8bit-ds2.csv

@tischi
Copy link
Author

tischi commented Apr 30, 2024

Maybe it helps for the debugging that this file
iMGL_AAV2MOI105_6h_DAPI_IBA1_well6_image2_C2.csv
does not have this issue.

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