WebFX Dynamic Webboard (Static Version)

WebFX WebBoard

Message Thread:

View All Messages
Back to WebFX

Re:How to exclude characters when sorting columns?, Ron B, June 21, 2004

Subject: Re:How to exclude characters when sorting columns? From: Ron B Date: June 21, 2004

To elaborate a little further:

110
86
152
144
122
145
50+140+50
140/100
228
150
230
140
170
180
150
160+290

needs to be sorted as:

50+140+50
86
110
122
140
140/100
144
145
150
150
152
160+290
170
180
228
230

(thus excluding '+140+50', '/100' and '+290')

..and this one atm does not sort properly no matter what sort type I use:

1,36
1,60
1,63
2,40
2,60
2,70
3,30
3,50
3,90
3,90
5,20
5,80
6,50
6,80
8,50
12,00

btw I'm using XP SP1 with IE6 and all updates

From: Ron B
Sent: June 21, 2004
Subject: Re:How to exclude characters when sorting columns?

Hi,

Thanks for the great Sortable Table script.

However, I've got some difficulty trying to exclude certain characters when sorting columns.

For instance, when sorting a column with the following values:

100

200

300

100/150

110+120

I would like the "/" and "+" and any characters after that to be excluded from the sorting process (not added or divided, just excluded).

Same issue with the following values (used for weight and (euro) currency):

1,20

1,33

1,36

0,12

What change do I need to make to have this working properly?

Would changing the "," in US-currency values to "." help and how do I do that?

TIA

Ron

Reply
Name:
Email:
Subject:
Enter your reply to this message below. HTML tags are not supported but words that start with http://, ftp:// or mailto: are converted to links.
To elaborate a little further: 110 86 152 144 122 145 50+140+50 140/100 228 150 230 140 170 180 150 160+290 needs to be sorted as: 50+140+50 86 110 122 140 140/100 144 145 150 150 152 160+290 170 180 228 230 (thus excluding '+140+50', '/100' and '+290') ..and this one atm does not sort properly no matter what sort type I use: 1,36 1,60 1,63 2,40 2,60 2,70 3,30 3,50 3,90 3,90 5,20 5,80 6,50 6,80 8,50 12,00 btw I'm using XP SP1 with IE6 and all updates From: Ron B Sent: June 21, 2004 Subject: Re:How to exclude characters when sorting columns? Hi, Thanks for the great Sortable Table script. However, I've got some difficulty trying to exclude certain characters when sorting columns. For instance, when sorting a column with the following values: 100 200 300 100/150 110+120 I would like the "/" and "+" and any characters after that to be excluded from the sorting process (not added or divided, just excluded). Same issue with the following values (used for weight and (euro) currency): 1,20 1,33 1,36 0,12 What change do I need to make to have this working properly? Would changing the "," in US-currency values to "." help and how do I do that? TIA Ron

View All Messages
Back to WebFX