Skip to content

Instantly share code, notes, and snippets.

@SupaFuzz

SupaFuzz/foroce_csv_column_string_format.md

Last active April 12, 2022 16:17
Show Gist options
  • Save SupaFuzz/cd06949af80f2bbe49c9eef7fdb167c6 to your computer and use it in GitHub Desktop.
Save SupaFuzz/cd06949af80f2bbe49c9eef7fdb167c6 to your computer and use it in GitHub Desktop.
Download ZIP
force CSV column to string format
Raw
foroce_csv_column_string_format.md

so you need a way to force a CSV column to be interpreted as a string.

Here's how you do that

take this row for instance:

column_1, column_2, 2346098560495680345968, column_3

open that in excel and you're going to get conversion to sceintific notation and then rounding, completely destroying the actual data

do this in the CSV source:

column_1, column_2, ="2346098560495680345968", column_3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment