Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[tcman41]

I have 170 1080P MKV movies under my movies tab, I went and hit the get tv & movie info for each of my movies and saved the data, I believe it resides in the sidecar file.

Under each of my movies one of my thumbnaill text lines is 'gross revenue', I also have 'gross revenue' as a column in panes.

When i go to sort my movies by 'gross revenue' it doesn't do it properly, is that because the info is in a sidecar file or is it because there is a dollar sign in front of each of the 'gross revenue' figures.

can anyone shed some light on this?

thanks
 T to the C  

[MrC]

The Gross Revenue field is just a "string" (a sequence of ASCII characters), so it will sort in character sequence order.

Unless there are changes to make this an integer (and this would likely be an issue, since there would be no currency indicator), you'll probably have to force sorting by manipulating the field via expression to be a number.  If you want to do this, can you share a few exact values for Gross Revenue? (I don't have any).

[tcman41]

The Gross Revenue field is just a "string" (a sequence of ASCII characters), so it will sort in character sequence order.

Unless there are changes to make this an integer (and this would likely be an issue, since there would be no currency indicator), you'll probably have to force sorting by manipulating the field via expression to be a number.  If you want to do this, can you share a few exact values for Gross Revenue? (I don't have any).

Inception - 2010
Revenue = $825,532,764

[MrC]

Try an expression column instead:

  If(isempty([Gross Revenue]), Unassigned, $RemoveCharacters([Gross Revenue], /,$))

This won't have thousands commas though.

[pcstockton]

Inception - 2010
Revenue = $825,532,764

So sad.  that bums me out.

[Matt]

Our string sorting system has smart number handling.

I wonder if it just doesn't like the commas?  Are you in a locale where comma means decimal?

[MrC]

@Matt: FYI - I originally only removed the $ and allowed the commas to remain, but the sorting was incorrect.  I had to remove the commas in the expression for tcman41.

[Matt]

This one is deceptively tricky.

The ambiguity between , and . as the decimal makes it hard to support either reliably.

And then, often dots are used as delimiters in downloaded filenames so assuming the dots mean "treat as a decimal number" for sorting could lead to other issues.

[vagskal]

Would it be possible to check if the string to sort contains only digits and . or ,? I guess there would not be many filenames that include only digits (at lest if the extension is included in the file name).