0

Extract names from compound names

Hi,

 

 Here is a function to get Ara from a list of compound names woth Ara inside :

 

let xBegin := substring(Nom,0,4)

let xLen := length(Nom)

if xBegin = "Ara " then substring(Nom,4,xLen) end

 

Ara vert -Ara bleu-Ara rouge

> Ara

 

How can modify it to get all the compound names of a list ?

 

Ara vert -Ara bleu-Ara rouge

 

Amazone à front bleu -Amazone à nuque jaune -Amazone couronné de lilas

 

Toucan bleu -Toucan montagnard- Toucan émeraude 

Thank you

4 replies

null
    • Fred
    • 3 yrs ago
    • Reported - view

    I'm unsure what you want to do? Your current code is looking for "Ara".

     

    What do you want it to look for now?

    • Addinsell
    • 3 yrs ago
    • Reported - view

    Hi Fred,

    I should like to get the first word of all the compound names of a list ?

    Ara vert -Ara bleu-Ara rouge > Ara

    Toucan bleu -Toucan montagnard- Toucan émeraude > Toucan

    Amazone à front bleu -Amazone à nuque jaune -Amazone couronné de lilas > Amazone

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    use this formula:

    substr(Nom, 0, index(Nom, " "))

     

    Steven

    • Addinsell
    • 3 yrs ago
    • Reported - view

    Thanks a lot Steven.

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 330Views