Announcement

Collapse
No announcement yet.

Assistance with a formula script

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Assistance with a formula script

    How can I extract the first letter of the first name, the first letter of the last name, and the last letter?

    And here's the example with your case:

    First name: John
    Last name: DOUNMINIC

    Desired result: JDC

    The corrected sentence would be:

    I tried this code, but it doesn't work


    PHP Code:

    prenom
    "John";
    nom"DOUNMINIC";

    first_letter_prenom LEFT(prenom1); 
    first_letter_nom LEFT(nom1); 
    last_letter_nom RIGHT(nom1); 

    someField string\concatenate(first_letter_prenomfirst_letter_nomlast_letter_nom); / 

  • #2
    Hi,

    PHP Code:
    $value string\substring(name, -11);  <---- last char
    output\print
    ($value);


    $value 
    string\substring(name01);  <---- first char
    output\print
    ($value);​ 
    You can test on demo

    Comment


    • #3
      Be sure to change name field to nom and prenom

      Comment

      Working...
      X