Lotus notes concatenating filed values using formula language

I need to concatenate two field values into a third field in lotus notes. Both the field hold multiple values which are separated by either comma,newline,semicolon and one of the field is name type and value populated from address book. The third field is of type reader.

jobby1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbonaciCommented:
I don't understand, what's the purpose of that?
If you enter non-existent name into Readers field (and you're not using backup Reader field) you'll end up loosing documents (only FullAccessAdmin can see them then).
mbonaciCommented:
If you simply want the third field to contain all the names from both first and second field, then it's easy, simply use:

    fieldName1 : fieldName2

as a formula for the third field.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CRAKCommented:
> ...separated by either comma,newline,semicolon...

That sounds like you need to @explode that field first. In that case mbonaci's example might read something like this:

@Explode(fieldName1; @NewLine + ",;") : fieldName2
Sjef BosmanGroupware ConsultantCommented:
I doubt very much the separated stuff... probably a document displays it with semicolons or so, but internally it's a list.

It might be more useful to use @Unique, and some fixed Reader role, to prevent the problem Marko depicts.
larsberntropCommented:
1 - please look at a document in a view, and use the property box to look at the two fields to confirm the type of data stored in them. It should read 'Text', 'Text List', 'Names', 'Readers' or 'Authors'.

2 - Look at the data. If there is a list of names in a field but it is of type text, or there are multiple names inside a single value, that needs to be exploded. Example 1 (No extra processing):
Field Name: Members
Data Type: Text List
Data Length: 34 bytes
Seq Num: 1
Dup Item ID: 0
Field Flags: SUMMARY NAMES

"lars.tom"
"Lars two"
"Lars three"
Example 2 (Extra processing)
Field Name: Members
Data Type: Text List
Data Length: 34 bytes
Seq Num: 1
Dup Item ID: 0
Field Flags: SUMMARY NAMES

"lars,tom"
"Lars two"
"Lars three"

3 - formulas for third field.  I've included an Admin role as I agree with Sjef
   1 - no extra processing: @Trim(@Unique("[Admin]":field1:field2))
   2 - extra processing: @Trim(@Unique(@Explode("[Admin]":field1; ","):field2))

4 - Important step: adjust the ACL on the database so at least Servers have the [Admin] role, so the stuff can replicate.  Also give the Admin role to someone managing the information in this db.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.