Lotus notes formula

1,555 pts.
Tags:
Lotus Notes
Lotus Notes Formulas
When I use computed text with formula of a multivalue field. it terminates value if semicolon ; is found in the field value. Any suggestion/solution to this problem. I mean to say for ex. abs is a multivalue field and computed text is having formula abc. Then if a value is entered in the field abc as "shjfdsh;sdhfsdjh hjsdf " then in computed text only text "shjfdsh" is showing and rest of the string after ; is terminated. How to solve this used computed field instead of computed text. if it is required to show in computed text then how can this be achieved?

Software/Hardware used:
lotus notes
ASKED: February 4, 2013  12:39 PM
UPDATED: February 4, 2013  1:00 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Computed text fields don’t understand multivalue fields, you must use the @Implode funtion to make the values a text string.

Example, if text list is the following in the “color” field:
Red
Blue
Green

Then the formula is:

@Implode(color; “; “)

To build a string of:

Red; Blue; Green

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • shivasanjay
    Suppose the string is given as REd;blue;;green how do you use the formula to return the exact string.in computed text
    1,555 pointsBadges:
    report
  • Stiletto
    If that's the input, what exactly do you want the output to be?  Use your own example.
    2,945 pointsBadges:
    report
  • shivasanjay
    Input in the field : red;green;blue;;
    out put in the computed text:  red;green;blue;;
    exactly same.
    Input could be any thing including ;,: newline etc
    out put in the computed field should be same.
     @Implode does not work.
    1,555 pointsBadges:
    report
  • Stiletto
    If the input could be anything, then let's take a look at the field that holds the input. If it's multivalue, then look at the properties, 3rd tab - what do you have selected for "Separate values when user enters" and "Display separate values with"?
    2,945 pointsBadges:
    report
  • SlikTool
    @Shivasnjay - @Implode will work, but you are looking for it to weed out empty values, to do this you have to add 2 extra steps. And there are 2 ways to do it. If it is just empty values, then use:

    imp := @Implode(color; ";");
    exp := @Explode(imp; ";"; 0);
    @Implode(exp; "; ");

    However, if the values may be empty or other characters like @Newline, then you have to use a slightly different approach. My recommendation would be to use the stuff above to get rid of empty strings, and then add additional code like the following:

    imp := @Implode(color; ";");
    rs := @ReplaceSubstring(imp; @NewLine; "");
    exp := @Explode(rs; ";"; 0);
    @Implode(exp; "; ");

    In the rs variable you could eliminate any other values by setting them to "", then the explode will remove those items and implode will only build a string from what is left.
    1,840 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following