WebFX WebBoard
Message Thread:
View All Messages
Back to WebFX
 How to exclude characters when sorting columns?, Ron B, June 21, 2004
     Re:How to exclude characters when sorting columns?, Erik Arvidsson, July 19, 2004
         Re:How to exclude characters when sorting columns?, Ron B, July 26, 2004
     Re:How to exclude characters when sorting columns? , Ron B, June 23, 2004
     Re:How to exclude characters when sorting columns?, Ron B, June 21, 2004
         Re:How to exclude characters when sorting columns?, Ron B, July 5, 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.


View All Messages
Back to WebFX