Ballistica
Highest Rated Comments
Ballistica199 karma
Or tags being converted to dates. For example, nearly all registered livestock in the spheres of my work (deer, sheep etc) use a somewhat standardised system of [number]/[yob], so animal tag 1 of 2020 will be 1/20, going all the way up to say 2000/20 or more in some cases. I import this data correctly, from csv, ususing the import tool, assigning the data as string/text. Perfect. However, any modification of this data, say the farmer put the colour in the tag, so the tags are P1/20 and I use "find and replace" or use an excel built-in formula to remove the leading P, instantly 1/20-12/20 is converted into dates.
WHY
I clearly defined it as text, I undertsand why it may convert it using a formular because then the data is defined as 'general' but why would find and replace lose its designation as a string. If I write any other scirpt, in R, or really anything and define something as a string and manipulate parts of that string, it stays a string unless I actively change its type.
The only way to make this work is to find and replace with leading ', I wish there was just a simply option somewhere that said "keep data formatted as defined" and left things exactly how I defined them.
Ballistica195 karma
If you travel the world....does that not just mean you are on a scavenger hunt for your income?
Ballistica318 karma
Half Life 3 Confirmed
View HistoryShare Link