IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#19977 - 09/05/06 10:48 AM One to Many Condition Help
cdogg Offline
Junior Member

Registered: 09/05/06
Posts: 2
Loc: romulus, MI
I have a CSV file that has one Bac being matched to many different VINS. Some of the records are duplicates.

For example:
_______________________________
BAC 10 VIN 1
BAC 10 VIN 2
BAC 10 VIN 3
BAC 10 VIN 4
_________________________________

I would like to print a form that has BAC 10 at the top, and a list of VINS below. How can I do that and still remove his duplicate names and duplicate addresses? I would like to end up with this:

____________________________
BAC 10

VIN 1
VIN 2
VIN 3
VIN 4
____________________________
I already tried putting an advanced line condition on the VIN. But it is not listing the many vins to the one bac. Also, do I need a condition on the bac? I basically want one info sheet sent to bac 10 with all his vins listed on it.
Thanks! confused

Top
#19978 - 09/06/06 03:51 AM Re: One to Many Condition Help
Chris_10 Offline
OL Guru

Registered: 06/24/04
Posts: 126
Loc: London, England
If you use a user defined emulation to split the datapage when the BAC changes, you would only have e.g. the BAC 10 details on the datapage. Then you can use a line condition on the VIN to remove duplicates. I would use the find function e.g. if the VIN was between column 8 and 13.

Code:
 =not(find(@(&current.line,8,13),8,0,13,&current.line-1)) 

Top


Moderator:  cosimo, OL Newsgroup Support