0

Same words which should not be repeated…

Hi

 In a database I have words written in exactly the same way that are repeated when I make a grouped classification.

What is the reason for this? How can I fix it?

 EG :

 Coliforme

>one time ok

 

Coraciiforme

>one time ok

 

-Galliforme

-Galliforme

>2 times : wrong !

 

-Passeriforme

-Passeriforme

-Passeriforme

>3 times: wrong !

 

Thank you

21 replies

null
    • saddinsell
    • 3 yrs ago
    • Reported - view

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

    • saddinsell
    • 3 yrs ago
    • Reported - view

    The same…not the sale !

    • John_Halls
    • 3 yrs ago
    • Reported - view

    Check for trailing spaces

    "Passeriforme" vs "Passeriforme " vs "Passeriforme  "

    This would give three groups

    • John_Halls
    • 3 yrs ago
    • Reported - view

    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

    • saddinsell
    • 3 yrs ago
    • Reported - view

    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 ?

    • John_Halls
    • 3 yrs ago
    • Reported - view

    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.

    • saddinsell
    • 3 yrs ago
    • Reported - view

    Hi John,

    Thanks

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

    • John_Halls
    • 3 yrs ago
    • Reported - view

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

    • saddinsell
    • 3 yrs ago
    • Reported - view

    Ok. Thanks.

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

    What is ”trim” ?

    • John_Halls
    • 3 yrs ago
    • Reported - view

    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

    • saddinsell
    • 3 yrs ago
    • Reported - view

    Thanks a lot.

    Here are two screenshots, what is the good one ?AB6B283C-3D11-49C3-9881-779DD22132E5

    • saddinsell
    • 3 yrs ago
    • Reported - view

    38095751-DBB7-4FF6-9749-41B177DF977B

    • John_Halls
    • 3 yrs ago
    • Reported - view

    trim(Ordre)

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    Trim is a command

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

    • saddinsell
    • 3 yrs ago
    • Reported - view

    Thanks a lot John and Mel.

    • saddinsell
    • 3 yrs ago
    • Reported - view

    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 !

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    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 ! :-))

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    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 ! :-))

    • saddinsell
    • 3 yrs ago
    • Reported - view

    Thank you Mel.

    • John_Halls
    • 3 yrs ago
    • Reported - view

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

    • saddinsell
    • 3 yrs ago
    • Reported - view

    Yes John, perfectly.

Content aside

  • 3 yrs agoLast active
  • 21Replies
  • 824Views