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.
6 replies
-
(Little wader mud bird)
-
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 :-)
-
Hi Addinsell.
--
replace(yourField, "limicole", "petit échassier limicole")where yourField is field that contains text (limicole) you want to replace
--
Fabio
-
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 ?
-
I think it is because "Calao" alone was on the beginning of the sort and the sort is stayed like that…
-
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.
Content aside
- 2 yrs agoLast active
- 6Replies
- 400Views