You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
What's the problem with opening this CSV in Excel? And are you planning to automate?
-
Here's what I do when I deal with csv data with very long numbers.
Save the csv locally, then Date > Get Data > Legacy Wizard (From Text) > delimit by comma and then chose to set the data format as Text for the problem data.
chez_jay
pifko
@Chalfie
Help me out here -
I have to grab codelists from here (https://www.opencodelists.org/codelist/nhsd-primary-care-domain-refsets/cpeptide_cod/20200812/)
the option to download as csv is there - but obvs downloading as csv and opening in excel is crazy and leads to corruption
"just copy and paste from the screen" is not what i want to do because that is fucking wrong.
what are my options?