topic Re: Showing Number a decimal point sequence in App Development

Showing Number a decimal point sequence

Markbhai — Wed, 24 Apr 2024 07:34:55 GMT

Hi there.

I have a series of documents which are version numbered, e.g. 5.1, 5.2, ...5.9, 5.10, 5.11 etc.

Any number which ends in a zero is converted to remove the zero (e.g 5.10 becomes 5.1)

I would like two things:

1 - Show numbers as thier original form, e.g. 5.10 should be 5.10

2 - Allow sorting on the field ascending e.g (5.1, 5.2, 5.3, 5.4, 5.5, 5.6, 5.7, 5.8, 5.9, 5.10, 5.11 etc)

Thanks for your help.

Mark.

MayilVahanan — Wed, 24 Apr 2024 07:39:38 GMT

Try like below

Load Dual(Text(Num), Num#(Replace(Num, '.',''))) as Num Inline
[
Num
5.1
5.2
5.3
5.10
5.11
];

Markbhai — Wed, 24 Apr 2024 07:56:05 GMT

Thanks for your help, so my field is called Control Number I should use:

Load Dual(Text([Control Number]), Num#(Replace([Control Number], '.',''))) as [Control Number] Inline

Thanks

MayilVahanan — Wed, 24 Apr 2024 08:03:11 GMT

Yes, if it is inline load, suppose if its from load statment

Load Dual(Text([Control Number]), Num#(Replace([Control Number], '.',''))) as [Control Number]

from yourdatasource;

Markbhai — Wed, 24 Apr 2024 10:13:58 GMT

Thanks

That worked great.