On Thu, 22 Jun 2006 14:00:09 +1200, "rebecca officer"
<[EMAIL PROTECTED]> wrote:
>I'm sorting a table and want to end up with the following order:
>5
>5E
>6
>
>Instead, it gives me:
>5
>6
>5E
>
>Can I change that?
Yes. The quick fix is to put a fixed space after the single
digits, with Esc spa
rebecca officer wrote:
put an M space in front of each number. This seems illogical but it
works.
It works because it makes *all* the entries character strings, vs. a
combination of some numbers and some strings. A non-breaking space is
also effective, and perhaps easier to type (ctrl-space
From what I know you can't. That's the standard ASCII-based sorting.
Numbers then characters. When FM sees 5and E together, it treats them
like a string.
A very rudimentary solution:
Maybe you could two columns? The column heading straddles two columns
Columns 1 | <-Column 2---
Hi Steve
Thanks for the suggestion. Someone else sent me another workaround off-list,
which I thought I'd post here to get it into the archive: put an M space in
front of each number. This seems illogical but it works.
For me, I'm sorting in a "database" document and copying some of the sorted
At 14:00 +1200 22/6/06, rebecca officer wrote:
>I'm sorting a table and want to end up with the following order:
>5
>5E
>6
>
>Instead, it gives me:
>5
>6
>5E
>
>Can I change that? If not, I'd appreciate other ideas for achieving what I'm
>after. The numbers are compulsory, but the letter E is arb
Carol J. Elkins wrote:
> Sorry, Ann, to keep my question simple, I didn't mention that
> each number is preceded by an alpha character. The numbers
> really look like this:
>
> M-509
> M-509
> M-5104
> M-5105
> M-5115
> M-512
> M-5120
>
> That sends a different message to Frame, signalling an
Sorry, Ann, to keep my question simple, I didn't mention that each number
is preceded by an alpha character. The numbers really look like this:
M-509
M-509
M-5104
M-5105
M-5115
M-512
M-5120
That sends a different message to Frame, signalling an alpha sort instead
of a numeric sort.
Sorry for
Good idea, Shlomo. I didn't mention, however, that each of these numbers is
a cross-reference to an actual document. Therefore, I can't edit the number
manually unless I open each of the 624 files and change the variable that
defines that file's document number.
But your idea is so spiffy (esp
amers@lists.FrameUsers.com
Subject: Re: table sort order
Hi, Carol:
At 11:30 AM -0700 3/7/06, Carol J. Elkins wrote:
>Framers, in the past when I sorted table rows containing numerical
>data, I could put up with Frame sorting on specific digits rather than
>the entire number string. For
Hi, Carol:
At 11:30 AM -0700 3/7/06, Carol J. Elkins wrote:
Framers, in the past when I sorted table rows containing numerical
data, I could put up with Frame sorting on specific digits rather
than the entire number string. For example, in an ascending sort,
Frame does this:
509
5104
5105
511
Carol,
You wrote:
Framers, in the past when I sorted table rows containing numerical data, I
could put up with Frame sorting on specific digits rather than the entire
number string. For example, in an ascending sort, Frame does this:
509
5104
5105
5115
512
5120
However, I'm now working with a
11 matches
Mail list logo