How do you sort item numbers targeting only specific numbers?

[matt323]

How can you sort item numbers, targeting only the numbers in the mock up file?
Example:

item number: GW14SO0000003
item company: GW
item location: 14SO
item counter: 0000003

How can I only sort the item by the last 7 digits "0000003"

Attachment 286458

[alvin-chung]

Hi, perhaps you can split the text using [Text to Columns] function and sort it?


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

[AlKey]

Actually you can sort by the last character by using formula in B3:

--=RIGHT(A,1)

then apply filter for A2 and B2 and sort in ascending or descending order.

	A	B
1
2	Item Number	Filter
3	GW30BF0000001	1
4	GW30BF0000002	2
5	GW14SO0000003	3
6	GW30BF0000003	3
7	GW14SO0000004	4
8	GW30BF0000004	4
9	GW14SO0000005	5
10	GW30BF0000005	5
11	GW13TZ0000006	6
12	GW30BF0000006	6
13	GW14SO0000007	7
14	GW30BF0000007	7
15	GW34SM0000008	8
16	GW13TZ0000009	9

[matt323]

Actually you can sort by the last character by using formula in B3:

--=RIGHT(A,1)

then apply filter for A2 and B2 and sort in ascending or descending order.

	A	B
1
2	Item Number	Filter
3	GW30BF0000001	1
4	GW30BF0000002	2
5	GW14SO0000003	3
6	GW30BF0000003	3
7	GW14SO0000004	4
8	GW30BF0000004	4
9	GW14SO0000005	5
10	GW30BF0000005	5
11	GW13TZ0000006	6
12	GW30BF0000006	6
13	GW14SO0000007	7
14	GW30BF0000007	7
15	GW34SM0000008	8
16	GW13TZ0000009	9

Can I just add a sort button to the item number heading? Then a drop down menu appears - Arrange by number -

[matt323]

How do you delete files from the file manager here on the forums???? I uploaded the wrong file on this forum?

[matt323]

How do you delete files from the file manager here on the forums???? I uploaded the wrong file on this forum? Seems like I can only upload files.

[AlKey]

Click on Go Advanced on the bottom of the screen on the right them scroll down where you will find Manage Attachments.

[matt323]

all my attachments are in the home folder. I do not see a delete option.

[Debraj Roy]

Go to UserCP >
in left hand bottom side.. Miscellaneous > Attachment..

Select desired File cy check box on right side..
In right bottom.. > delete Selected..

[matt323]

Ok I did that, but the files are still uploaded in the main file manager where you upload.

[Debraj Roy]

Now its a invalid file...

Check if you can edit your post.. you can edit the [attach].... portion.