0

To change a word of a field with a formula ?

 Hi

 

Can someone tell me the way to change a word of a field with a formula ?

ie change the word "limicole" by "petit échassier limicole".

In fact, add "petit échassier" in front of "limicole".

Thank you.

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    (Little wader mud bird)

    Like
  • If this is to happen for all occurancess in the table for that field

    Then do a table view table from with that filed showing unless you already have that field on an existing view

    type the name you want to alter to limit the search to show only the records with that name

    Then go into the grear wheel and select multiple update

    on the field iyou want to alter selection chnage the Don't change tag to read Assign Constant Value

    and retype the complete name in the box that you want to store

    press next - this will show yu the inteneded changes to that field (in blue)

    press execute update - if you are happy :-)

    Like
    • Fabio
    • noCodeApp
    • Fabio
    • 1 yr ago
    • Reported - view

    Hi Addinsell.

    --

    replace(yourField, "limicole", "petit échassier limicole")

    where yourField is field that contains text (limicole) you want to replace 

    --

       Fabio

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    A great thanks to you both.

     

    I tried the Fabio's solution; it works but there is a little issue.

     

    The names are differents "Calao" > "petit Calao"

    As you can see on the shot the sorting is false…

    Why ?

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    I think it is because "Calao" alone was on the beginning of the sort and the sort is stayed like that…

    Like
    • Addinsell
    • Addinsell
    • 1 yr ago
    • Reported - view

    I tried also the Mel's solution : it works and I have not the issue of the bad sort.

    But there must be a solution for the Fabio's solution.

    Like
Like Follow
  • 1 yr agoLast active
  • 6Replies
  • 374Views