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 arbitrary. I
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
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
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 space n (three
Hi everyone
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 arbitrary. I tried
making it a comma instead but
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
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
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
On Thu, 22 Jun 2006 14:00:09 +1200, "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?
Yes. The quick fix is to put a fixed space after the single
digits, with Esc space n (three
Re the table sort order problem wherein Frame sorts alpha-numeric table
data on specific digits rather than the entire number in the string (e.g.,
M-509, M-5104-, M-512).
Rick Quatro solved this with a slick FrameScript that sorts an 41-page
table in the blink of an eye.
Thanks everyone
Re the table sort order problem wherein Frame sorts alpha-numeric table
data on specific digits rather than the entire number in the string (e.g.,
M-509, M-5104-, M-512).
Rick Quatro solved this with a slick FrameScript that sorts an 41-page
table in the blink of an eye.
Thanks everyone
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
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
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 alpha
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 41-page table
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
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
@lists.frameusers.com] On
Behalf Of Peter Gold
Sent: Tuesday, March 07, 2006 3:57 PM
To: Carol J. Elkins; framers at 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 numeri
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
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
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
22 matches
Mail list logo
