HaugeReidar
Aug 5, 2011, 04:49 AM
Hi!
I have a large database, where I need to count different items how many times they have been run over the last few years. I've got pretty much everything figured out, except this:
The database is quite stupid, in one column there is a lot of info (timestamp, explanation, the thing I need, and somethimes something after that as well, with spaces between them (not allways the same amount either). I'm reading about exctrating part of string. But don't quite get the hang of it. I have 3 characters, both letters and numbers, that I need to separate from the column into a new one hopefully. The 3 characters change, but some are the same, I want to count them to see how many it is of each.
Hope any of this makes sense,
Thanks!
I have a large database, where I need to count different items how many times they have been run over the last few years. I've got pretty much everything figured out, except this:
The database is quite stupid, in one column there is a lot of info (timestamp, explanation, the thing I need, and somethimes something after that as well, with spaces between them (not allways the same amount either). I'm reading about exctrating part of string. But don't quite get the hang of it. I have 3 characters, both letters and numbers, that I need to separate from the column into a new one hopefully. The 3 characters change, but some are the same, I want to count them to see how many it is of each.
Hope any of this makes sense,
Thanks!