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?
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.
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?