Hello. I am trying to sort every line of a table; the table has 1000+records with data as follows:
LA60RH90RW23LE9LS10RE12RA140LH2RS5RK780LW2LK7
Every line has TWO letters and THREE "digits" twelves times.
I would like to sort every line in ascending order. For example the end result would be LW2LH2RS5LK7LE9LS10RE12RW23LA60RH90RA140RK780 .
I tried the bubble sort using a different programming language and it worked.However, I need to use Access since the amount of data is pretty big. Any help would be highly appreciate it, and just for the record I am a novice programmer and I don't how or where to start. Thanks a lot
The function I used and worked is described below:
LA60RH90RW23LE9LS10RE12RA140LH2RS5RK780LW2LK7
Every line has TWO letters and THREE "digits" twelves times.
I would like to sort every line in ascending order. For example the end result would be LW2LH2RS5LK7LE9LS10RE12RW23LA60RH90RA140RK780 .
I tried the bubble sort using a different programming language and it worked.However, I need to use Access since the amount of data is pretty big. Any help would be highly appreciate it, and just for the record I am a novice programmer and I don't how or where to start. Thanks a lot
The function I used and worked is described below:
Code:
void sort(int Numbers[], int size) {
for (int First = 0; First < (size - 1); First++) {
for (int Inside = 0; Inside < (size - (First + 1)); Inside++) {
if (Numbers[Inside] > Numbers[Inside + 1]) {
int Stored = Numbers[Inside];
char *Temp = Parts[Inside];
Parts[Inside] = Parts[Inside + 1];
Numbers[Inside] = Numbers[Inside + 1];
Numbers[Inside + 1] = Stored;
Parts[Inside + 1] = Temp;
}