Search exact name…
Hi
If I type Like "Ara" in the filter box of a column I get :
Ara bleu
Ata écarlate
Ara hybride
But alsoAraçi de Frantzius
Carara
Tangara
Marabout
Amarante du Sénégal
How could I get only :
Ara bleu
Ata écarlate
Ara hybride
Or
Ara alone ?
Thanks
27 replies
-
This works
="Ara" or like "Ara " or like " Ara"
Regards John
-
Thanks but as I said
="Ara" or like "Ara " gives aldo :
Carara
Tangara
Marabout
Amarante du Sénégal
I just want :
Ara bleu
Ata écarlate
Ara hybride
-
The like "Ara " part has a space in the quote, at the end. I had it working exactly as you desired for me.
-
The like "Ara " part has a space in the quote, at the end. I had it working exactly as you desired for me.
-
Thanks again John
Sorry it does not work for me…
Strange…
-
Sorry I typed ;
= "Ara " rather than like "Ara "
It works but I get also :
Tangara à joues noires
Tangaravemeraude
-
Tangara emeraude
-
By the way
I tried so with the space before the word to get all the words ”finishing by” but I can't make it work…
-
Ah yes, you are right, I hadn't thought of that one. Tangara emeraude would indeed be included.
-
Hi
Why ”Tangara emeraude” and ”Tangara à joues noires” are included ?
I thought the space after Ara should return only when Ara is alone, not stuck on a word ?
What about the space before for finishing by,that does not seem to work ?
-
You are conducting an instring search which beausre of the like command will look for an exact or near matcg through the whole data in the field
Thus - like "Ara " finds an exact match even when it placed in the word Tangara because you have a space next to it. and you incli]uded this in the criteria
-
Ok
So there is no way to return only the "Ara" that are alone before a space as :
Ara bleu et doré
Ara écarlate
Ara vert
Ara Macao
-
you probably use trim combinde with liek to achiebve this
https://ninox.com/en/manual/calculations/text-date-functions
-
If your field is called Name then add a formula field with this formula
"*" + replace(Name, " ", "*") + "*"
It will turn Ara into *Ara* and Ara Vert into *Ara*Vert* etc.
Filter on this formula field for *Ara* will give you what you are looking for.
-
Hi John,
I tried your function to get Ara only with a search but I got this error :
"The function is not defined : replace (string,string,string) on the line 1, column 32"
Thanks to check, but maybe I made a mistake somewhere…
-
You have used remplacer rather than replace in your function. Is that the problem?
-
Sorry, I put the french word !!
It works now but where must I type the *Ara* ?
In the formule column that does not work neither in the "Nom" column…
-
By the way, the formule column has the 0 number at each raw…
-
Must I create a button for that function ?
-
Hi
No need for a button. Just add this additional field
Have it show in the list
Then type your filter into this field
And you have your desired filtered list
Regards John
-
Great ! Works well.
Thanks again !
And if I search for Ara alone ?
-
Would it be possible to have this way of searching in the kanban view.
In fact there are no columns, no filter either in that view…
-
You can search in the table view for *Ara* and this will give the same result. This means you can seach in a kanban view too.
-
and you can even use colour to make the Kanban swim lanes look a little cooler :-)
-
Also in case you don't know - you can drag and drop the swim lanes (columns) by clicking and holding the column title
you also add the colour and icons by clicking into the header
Content aside
- 3 yrs agoLast active
- 27Replies
- 1202Views