Solved

Input Translation Question

Posted on 2008-10-06
3
578 Views
Last Modified: 2013-12-18
I have 2 fields on a form:

Field 1  is called "Current"
Field 2 is called "Remove"

Both of these are multi value dialog lists

I need to create an input translation formula that will do the following:

If a value in "Remove" is not contained in "Current" then it will remove this value from "Remove"

I see that a listbox will do this automatically anyway, but I'd really like to keep this field as a dialog list.

I was thinking something along the lines of:

@if(!@ismember...
@replace...

but I can't get this to work.

Any ideas/suggestions greatly appreciated!
0
Comment
Question by:shuboarder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 250 total points
ID: 22650401
If a value in "Remove" is not contained in "Current" then it will remove this value from "Remove"

superfluous:= @Trim(@Replace(Remove; Current; ""));
reduced:= @Trim(@Replace(Remove; superfluous; ""));

Field Remove:= reduced

Something along these lines...
0
 
LVL 21

Author Comment

by:shuboarder
ID: 22651251
Perfect!
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 22651384
:-))
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
Suggested Courses

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question