Same words which should not be repeated…

Here one can see inside each group that the words are the sale :

The same…not the sale !

Check for trailing spaces

"Passeriforme" vs "Passeriforme " vs "Passeriforme  "

This would give three groups

If so use Update multiple records... and for the Ordre field Assigne calculated value. Use the formula trim(Ordre) Click Next to see a preview of the the result before you Execute Update

Thanks Mel

Ihave some questions : 

-I typed "Passeriforme" vs "Passeriforme" vs "Passeriforme in the filter field and nothing has been displayed in the ordre column.

-How do I update multiples records ?

-how do I assigne calculated value ?

-how do I use the formula trim ?

It's John. It's not to do with filtering. See my instructions above, and also look at

https://ninox.com/en/manual/tables/update-multiple-values

Choose Assign calculated value for the Ordre field. Use trim(Ordre) for the calculation.

Hi John,

Thanks

 As you can see in the screen shot above there is no update option in the order field !

Hi Its the one called Assigner ue valeur calculee. Regards John

Ok. Thanks.

What do you mean by ”Use the formula trim(Ordre)” ?

What is ”trim” ?

A box appears to the right once you select Assigner ue valeur calculee. Click in this and the script editor appears. You can type trim(Ordre) and then click OK.

trim is a function that takes away spaces at the start and end of the field

Thanks a lot.

Here are two screenshots, what is the good one ?

trim(Ordre)

Trim is a command

it will strip out leading and trailng spaces in the string search

Thanks a lot John and Mel.

Just a question

 How can spaces that are at the start and end of a field create this kind of issue ?

…Car  Car…  is always Car !

can'r be specific abiut your particular issue 

But you search for Like ("Car")

as far as you are concernced you looking for car 

as far asNinox is concerned you are looking from SOMETHING LIKE Car

thus it will see Car but with and with a leading and traing space as fair game to be included in the result

"Car" - " Car" - "Car " - "CarMel" - "Redcar" - 

with trim used you would be trimming out the spaces - which may or may be relevant to the result you are trying to get

Personally I do like commands that full test a text strings value ie instring.. But Ninox does not appear to have this (unless someone knows better ! :-))

Ooops - look like my medication is making me a bit trigger happy!!

all should have read as :-

Can't be specific about your particular issue 

But say you search for Like ("Car") 

as far as you are concernced you are looking for he exact word "Car" 

as far as Ninox is concerned Like means you are are looking for SOMETHING LIKE "Car"

thus it will see "Car" and also anything with a space around it (leading and trailing) as fair game to be included in the result.

ie "Car" - " Car" - "Car " - "CarMel" - "Redcar" - 

and as John said earlier you would have different groups of results.

With the use of trim - would be ignoring spaces(trimming) - which may or may not be relevant to the any result you are trying to achieve.

Personally I do like commands that fully test a text strings value.  ie 'instring'.. But Ninox does not appear to have this command (unless someone knows better ! :-))

Thank you Mel.

I'd be interested to know, did it work and remove the multiple instances of the same group?

Yes John, perfectly.