Replace text

[M.J. Schürhoff]

Hi,

I've got a field ProductCode which sometimes contains duplicate text
strings, e.g.
sp1
sp2
bs
sp1
fo1
bs

Is there a way to remove the duplicates (with replace) so I get the
following list:
sp1
sp2
bs
fo1

Kind regards,
M.J. Schürhoff

[John Weinshel]

Easiest way is to use some flavor of the ValueListItems() function, because
value lists use only one iteration of a value.

Create a self-join relationship ("Self") based on a value unique to each
record, such as an auto-entered serial number, or a stored calc--
Status(CurrentRecordID). Then, create a value list ("Items") that uses the
related field:

Self::ProductCode.

Next, use Replace, or loop through the records using Set Field[], and change
the value in ProductCode to:

ValueListItems("Your_File.fp5", "Items")

Note that the Design functions are fussy about spelling and syntax.

--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance

"M.J. Schürhoff" <m.j.sc...@chello.nl> wrote in message
news:e1c0tt8jbjjje3mij...@4ax.com...