How to get an "index" of names.

#1

Hello,

How to get an "index" of names.
E.g. I do have 20 records, containing Names of Cities (fieldname City)
Sorting to "City", duplicate names are following.

Record 1 --- Alabama
Record 2 --- Alabama
Record 3 --- Amsterdam
Record 4 --- Amsterdam
Record 5 --- Amsterdam
Record 6 --- Amsterdam
Record 7 --- Kopenhagen
Record 8 --- Kopenhagen
Record 9 --- New York
Record 10 --- New York
Record 11 --- New York
Record 12 --- Oslo
Record 13 --- Paramaribo
Record 14 --- Paris
Record 15 --- Paris
Record 16 --- Tokyo
Record 17 --- Tokyo
Record 18 --- Tokyo
Record 19 --- Tokyo
Record 20 --- Viena

I want only a *numbered* index output list shown
unique City names.

Nr 1 --- Alabama
Nr 2 --- Amsterdam
Nr 3 --- Kopenhagen
Nr 4 --- New York
Nr 5 --- Oslo
Nr 6 --- Paramaribo
Nr 7 --- Paris
Nr 8 --- Tokyo
Nr 9 --- Viena

How to get only unique City names?
How to get nice follow up numbers?

Thanks for input.
Regards, Léon Obers

#2

leon.obers (AT) iae (DOT) nl wrote:

Quote:

Hello,

How to get an "index" of names.
E.g. I do have 20 records, containing Names of Cities (fieldname City)
Sorting to "City", duplicate names are following.

Record 1 --- Alabama
Record 2 --- Alabama
Record 3 --- Amsterdam
Record 4 --- Amsterdam
Record 5 --- Amsterdam
Record 6 --- Amsterdam
Record 7 --- Kopenhagen
Record 8 --- Kopenhagen
Record 9 --- New York
Record 10 --- New York
Record 11 --- New York
Record 12 --- Oslo
Record 13 --- Paramaribo
Record 14 --- Paris
Record 15 --- Paris
Record 16 --- Tokyo
Record 17 --- Tokyo
Record 18 --- Tokyo
Record 19 --- Tokyo
Record 20 --- Viena

I want only a *numbered* index output list shown
unique City names.

Nr 1 --- Alabama
Nr 2 --- Amsterdam
Nr 3 --- Kopenhagen
Nr 4 --- New York
Nr 5 --- Oslo
Nr 6 --- Paramaribo
Nr 7 --- Paris
Nr 8 --- Tokyo
Nr 9 --- Viena

How to get only unique City names?
How to get nice follow up numbers?

Thanks for input.
Regards, Léon Obers

--
Vr.groet - regards, Léon Obers

Reacties per mail, vervang "invalid" door "cc" in het adres.
Reactions by mail, exchange "invalid" by "cc" within address.

#3

Or . . . if you can get by without the numbers in the list, create a
Value List for the Cities and try the following calulation:

ValueListItems ( dbname , valuelist )

Example ("Customers.fp5", "City")

Martin Trautmann <t-use (AT) gmx (DOT) net> wrote in news:slrnde9jrd.c0c.t-use@ID-
685.user.individual.de:

Quote:

On Mon, 25 Jul 2005 10:28:20 +0200, Léon Obers wrote:
How to get an "index" of names.

Solution 1: summary export - check the manuals for subsummary parts.

I want only a *numbered* index output list shown
unique City names.

what for do you need numbers?

Solution 2: calculated of scripted 'manual' solutions.

Solution 3: export to $file,
sort -u $file

... and for numbers do an extra pipe to grep -n:

sort -u | grep -n .
... does return

1:Alabama
2:Amsterdam
3:Kopenhagen
4:New York
5:Oslo
6:Paramaribo
7:Paris
8:Tokyo
9:Viena

BTW: there's no Win 7.3 version, but 7.0.3 only. Since you name Win, I
guess you don't have a Linux at hand (Mac OSX comes with a full unixoid
system). Then try Solution 1 first.

#4

Martin Trautmann schreef:

Quote:

On Mon, 25 Jul 2005 10:28:20 +0200, Léon Obers wrote:
How to get an "index" of names.

Solution 1: summary export - check the manuals for subsummary parts.

Thanks for input. I shall examine these possibilities.
In my language it is called by another name, but found it now in my
language (sub-résumé and "splitsvelden").
Always a little more difficult to look to solutions in my own language.

Quote:

I want only a *numbered* index output list shown
unique City names.

what for do you need numbers?

Handy list to see the amount of names immidiately.
Also easy for checking.

Quote:

Solution 2: calculated of scripted 'manual' solutions.

Solution 3: export to $file,
sort -u $file

... and for numbers do an extra pipe to grep -n:

sort -u | grep -n .
... does return

Quote:

BTW: there's no Win 7.3 version, but 7.0.3 only.

Sorry, mistake ;-)

Quote:

Since you name Win, I
guess you don't have a Linux at hand

No.

Quote:

(Mac OSX comes with a full unixoid
system). Then try Solution 1 first.

Thanks.
Regards, Léon Obers

#5

W Brent Simon schreef:

Quote:

Or . . . if you can get by without the numbers in the list, create a
Value List for the Cities and try the following calulation:

ValueListItems ( dbname , valuelist )

Example ("Customers.fp5", "City")

Mmm, to old example I guess (fp5). I can not find that example. Have to
see to more old Filemaker application in my cupboard. Maybe I will find
Filemaker 4 (even more old).

Thanks for input. Léon Obers

#6

Well, answering at Google it seems sometimes brings strange behaviour of
messages, by getting total new messages out of this thread.
So try again using Netscape 7.1

Martin Trautmann schreef:

Quote:

On Mon, 25 Jul 2005 10:28:20 +0200, Léon Obers wrote:

How to get an "index" of names.

Quote:

Solution 1: summary export - check the manuals for subsummary parts.

Thanks for input. I shall examine these possibilities.
In my language it is called by another name, but found it now in my
language (sub-résumé and "splitsvelden").
Always a little more difficult to look to solutions in my own language.

Quote:

I want only a *numbered* index output list shown
unique City names.

what for do you need numbers?

Handy list to see the amount of names immidiately.
Also easy for checking.

Quote:

Solution 2: calculated of scripted 'manual' solutions.

Solution 3: export to $file,
sort -u $file

... and for numbers do an extra pipe to grep -n:

sort -u | grep -n .
... does return

Quote:

BTW: there's no Win 7.3 version, but 7.0.3 only.

Sorry, mistake

Quote:

Since you name Win, I
guess you don't have a Linux at hand

No.

Quote:

(Mac OSX comes with a full unixoid
system). Then try Solution 1 first.

Thanks.
Regards, Léon Obers

#7

leon.obers (AT) iae (DOT) nl wrote in news:1122459020.408958.294610
@g44g2000cwa.googlegroups.com:

The example below was for a calculated field using FMP 7.03. Just in case
there was any confusion.

Quote:

W Brent Simon schreef:
Or . . . if you can get by without the numbers in the list, create a
Value List for the Cities and try the following calulation:

ValueListItems ( dbname , valuelist )

Example ("Customers.fp5", "City")

Mmm, to old example I guess (fp5). I can not find that example. Have to
see to more old Filemaker application in my cupboard. Maybe I will find
Filemaker 4 (even more old).

Thanks for input. Léon Obers

#8

W Brent Simon schreef:

Quote:

leon.obers (AT) iae (DOT) nl wrote in news

The example below was for a calculated field using FMP 7.03. Just in case
there was any confusion.

Yes there is a confusion because the example you wrote about do have
the extention "fp5". That is not a file-format to handele with FMP 7.03
under normal conditions (should be at least "fp7"). The only way to
work with it, is converting to the file format of FMP 7.03.
So I guess it is an example of older Filemaker application.

Quote:

W Brent Simon schreef:
Or . . . if you can get by without the numbers in the list, create a
Value List for the Cities and try the following calulation:

ValueListItems ( dbname , valuelist )

Example ("Customers.fp5", "City")

Mmm, to old example I guess (fp5). I can not find that example. Have to
see to more old Filemaker application in my cupboard. Maybe I will find
Filemaker 4 (even more old).

Thanks for input. Léon Obers

#9

ok - I understand now. This will work for FMP 7.03. I revised the
formula.

ValueListItems ( dbname , valuelist )

Example ("Customers.fp7", "City")

Hope this helps.

leon.obers (AT) iae (DOT) nl wrote in
news:1122513162.783116.301660 (AT) g47g2000cwa (DOT) googlegroups.com:

Quote:

W Brent Simon schreef:
leon.obers (AT) iae (DOT) nl wrote in news

The example below was for a calculated field using FMP 7.03. Just in
case there was any confusion.

Yes there is a confusion because the example you wrote about do have
the extention "fp5". That is not a file-format to handele with FMP
7.03 under normal conditions (should be at least "fp7"). The only way
to work with it, is converting to the file format of FMP 7.03.
So I guess it is an example of older Filemaker application.

W Brent Simon schreef:
Or . . . if you can get by without the numbers in the list,
create a Value List for the Cities and try the following
calulation:

ValueListItems ( dbname , valuelist )

Example ("Customers.fp5", "City")

Mmm, to old example I guess (fp5). I can not find that example.
Have to see to more old Filemaker application in my cupboard. Maybe
I will find Filemaker 4 (even more old).

Thanks for input. Léon Obers

#10

W Brent Simon wrote:

Quote:

ok - I understand now. This will work for FMP 7.03. I revised the
formula.

ValueListItems ( dbname , valuelist )

Example ("Customers.fp7", "City")

Hope this helps.

This afternoon or tomorrow I wil try the example.
Thanks for input.

--
Vr.groet - regards, Léon Obers

Reacties per mail, vervang "invalid" door "cc" in het adres.
Reactions by mail, exchange "invalid" by "cc" within address.