How 2 get scheules to understand 2.1 vs 2.10...?

[Mats Knutsson]

Hi,

I have a property with set values 2.1 , 2.2, ....2.10 etc and Archicad sorts logically the schedule as 2.1, 2.10, 2.2 etc... Any smart tricks to come around this?

/Mats

Operating system used: Windows

[Mathias Jonathan]

An hidden property that will transform element with 1 decimal place to a 2 decimal place , injecting a 0 after the "," ?

Using split to retrieve data after "," then length then a concatenation if lenght =1 ?

[Stefan L_]

Smart trick?

Silly approach?

You can hide the helper column, the sorting persists.

[Mats Knutsson]

I did try these methods but since the table is using a header the hidden sorting column doesn't work with the header. I'll post a screenshot when I'm on it again. Did an ugly workaround just changeing 1 to 01, 2 to 02 etc.. Fugly...

[Lingwisyer]

Does changing your delimiter change how it sorts?

[runxel]

Wasn’t there some improvement planned in this regard or am I tripping @James B ?

[James B]

Hi @runxel 

When I change the Element ID for example of 3x slabs to: 2.1, 2.2 and 2.10 then the Schedule shows these in the expected order (1, 2, 10).

Just tried in AC29. If this is not occurring, I'd suggest to let our support teams know, so they can investigate further. Maybe this is different between number vs string type values? I didn't have time to check deeper yet. This may have also been improved in the last few versions - as we've worked on Schedules.

We have made improvements with sorting of Viewpoints in Archicad 30 for example, to use this natural sorting method.

[runxel]

Ah wait, @Mats Knutsson are you still on 27 as your signature suggests? If yes, then your thread might be resolved already.

I couldn’t try it rn because I’m nowhere close to my pc 😉

Thanks for replying so fast, James!