Jump to content

Can you we used a fusion or other variable substitution in a formula?


This topic is 2328 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I speak with a translator,
If anyone can help me I have a question
Can you we used a fusion or other variable substitution in a formula?
Thank you
I did some test but it does not work following my example
Shmuel

Definir ( [
machaine = " f1"
] ;
 
SupprimerEspace ( 
Substituer ( Minuscule ( f1 ) ;
                                               [ "Bonjour" ; "<<l::A1>>" ] ;
                                               ["hola" ; "salut"" ] ; 
                                               ["gracias" ; "merci"] ; 
                                              ["adios" ; "bye-bye"" ] ; 
                                       
)) 
)

 

Link to comment
Share on other sites

Perhaps an example showing the input and the expected output would make this clearer.

Offhand, I see that:

  1. You are defining a variable machaine - but I don't see that you use it anywhere;
  2. You will never find the string "Bonjour" in a text that has been converted to lower-case.

 

 

Link to comment
Share on other sites

My need and replace a lot of words with other words
There comes a translator of words pres recorded in a language (variable) also replace other pres recorded words in another language (another variable)

imagine an excel sheet that is imported into Filemaker to which the check should have chaqu'une the topic and each record to replace a word (English) by another word (french)
Biensur Each one of the words is in a word biblioteque ($ = $ English French)

-------------------

I find a feature that seems to substitute a variable here but I do not know if these exatement I needhttp://www.briandunning.com/cf/896
 
It seems this feature fits my requirements ie replace a text with a variable I wonder if it is good for me, obviously yes but I do not understand the example
If someone can give me a small example would be really nice
Thank you

33. SubstituteValuesInText__cf (_TEXT; _searchValues; _replaceValues) full.pngfull.pngfull.pngfull.pnghalf.png    Note moyenne: 4,3 Steve Hearn, Développement CoreSolutions http://www.coresolutions.ca substituts multiples searchvalues dans le texte avec replaceValues correspondant.
 

Quote

Let(

    [        _searchString = GetValue (_searchValues; 1);
        _replaceString = GetValue (_replaceValues; 1);
        _xchgList = Substitute (_TEXT; _searchString; _replaceString);
        _countValues = ValueCount (_searchValues)
    ];
    Case (
        _countValues> 1;
        SubstituteValuesInText__cf (
            _xchgList;
            ValeursFin (_searchValues; _countValues - 1);
            ValeursFin (_replaceValues; _countValues - 1)
        );
        _xchgList
    )
)
 
 
/ *
fonction SubstituteValuesInText__cf
 
Auteur d'origine (SubstituteValues: < http://www.briandunning.com/cf/851 >)
Michael Horak, * COMMENTAIRE visuelle Réalisation
 
Modifié par Steve Hearn, CoreSolutions Development Inc
7 août 2008
 
Format
SubstituteValuesInText__cf (_TEXT; _searchValues; _replaceValues)
 
Paramètres
_TEXT - une expression de texte ou champ de texte
_searchValues - toute liste de valeurs à trouver dans _TEXT retour délimité
_replaceValues - toute liste de retour de valeurs délimitées pour remplacer _searchValue avec
 
Description
Substituts multiples searchValues dans _TEXT avec les replaceValues correspondants. Les _searchValues et _replaceValues sont destinés à être une paire assortie, généralement le résultat d'une fonction de liste. Développé à l'origine pour rechercher et remplacer des chaînes définies dans un tableau.
 
Exemple
_TEXT: Ceci est un exemple de lettre de champs de fusion comme << firstName >> et << orgName >> qui sont des noms de champs conviviaux. Une table a une liste de ces domaines conviviales ainsi que leur «vrai» nom de domaine correspondant.
 
_searchValues: << firstName >> << ¶ orgName >>
 
_replaceValues: << CM__CON__Contact__102 :: prenom >> << ¶ CM__ORG__Organization__107 :: orgName >>
 
sortie: Ceci est un exemple de lettre de champs de fusion comme << CM__CON__Contact__102 :: prenom >> et << CM__ORG__Organization__107 :: orgName >> qui sont des noms de champs conviviaux. Une table a une liste de ces domaines conviviales ainsi que leur «vrai» nom de domaine correspondant.
 
* /

 

Edited by SHMUEL
Link to comment
Share on other sites

3 hours ago, SHMUEL said:

imagine an excel sheet that is imported into Filemaker to which the check should have chaqu'une the topic and each record to replace a word (English) by another word (french)

Seems very similar to:
http://fmforums.com/topic/98837-automatic-translation-with-dictionary-table/#comment-449508

Make sure to read the limitations explained there.

 

3 hours ago, SHMUEL said:

I wonder if it is good for me

Only you can answer this.

Link to comment
Share on other sites

This topic is 2328 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.