Bioequivalence and Bioavailability Forum

Hi Hötzi,
hi all,

❝ I don’t know what you want to achieve but (...)

Well, some degree of sanity is part of my general goals. But obviously, in that case I should not have gone into bioequivalence to start with.

Some days ago I received a csv file with dates like "03/Apr/2024" for ~5000 data points or so (cancer PD marker level, subjects, visits, timings, and a Brazilian other columns). There are repeats in the data and I need to extract the latest data for of such repeats as these will be the ones used for stats. So, I have to sort the data by subject and by date.
Since %b as Mittyri says uses a deep C call which queries the locale, there is no easy way of doing this.
The solution I see is to translate every month abbrev in the data to the corresponding month abbrev of my locale and only then can it be sorted. Same thing if I convert the month abbrev to integer. Both options are equally viable. Clumsy, but I will get there.

I do not in any way have influence on the way the data file is generated or which date format the other party decide to use before sending it to me.