0

To replace a letter or a number at the end of a word

Hi,

Can someone tell me how to replace a letter or a number at the end of a word in a list ?

 

Ex 127 > 128

 Elephand > Elephant

 

Thank you

10 replies

null
    • Fred
    • 3 yrs ago
    • Reported - view

    Are you going to be replacing the last letter or number with a static letter or number, i.e. everything will end with "X". or will it vary depending on what it finds?

    If it varies what are the different ways you need to change the last letter?

    • Addinsell
    • 3 yrs ago
    • Reported - view

    Hi Fred,

     

    I have 230 Elephand

    And I'd like to change for  230 Elephant

     I have 32 numbers 127

    And I'd like to change for 32 numbers 128

    • Fred
    • 3 yrs ago
    • Reported - view

    if this is just a data correction job then:

    1) filter for Elephand

    2) right click on a number in the table and click on Select All

    3) click on the Gear icon and select update multiple records

    4) select the appropriate field and type in the new data

    5) verify that the change is what you want and then click on Execute Update

    repeat for all other changes.

    • Addinsell
    • 3 yrs ago
    • Reported - view

    Thanks Fred,

    "2) right click on a number in the table and click on Select All"

     Is there another way ?

    I am with an Ipad and there is a bug that prevents me to to select a column (I contacted the Ninox support and they are awate of that)

    • Fred
    • 3 yrs ago
    • Reported - view

    ok, to clarify step 2.

    2) for iPad user,  in table view, click on the rectangle icon with two lines that is next to the Search box then click on Select All

    • Addinsell
    • 3 yrs ago
    • Reported - view

    Ok thanks Fred

     

    I did what you said but it does not work

    I filter  "Accipiter" in my colum "Nom"

    I go to the gear icon

    I select "massives modifications of datas"

    Down, I select "update all the records visibles"

    (Or update all the selected records)

    I go to the fiels "Name" and select "assign a fixed value"

    I type "Accipiterus"

    I click on "Next"

    And "do the modifications"

    Accipiter is always there…

    • Fred
    • 3 yrs ago
    • Reported - view

    you have to do a select all before you do a "massive modification of datas".

    after you typed in "Accepiterus" and clicked Next did it show any records being modified or was the screen blank?

    • Addinsell
    • 3 yrs ago
    • Reported - view

    -I did it !

    -Yes it was written in blue Accipiterus

    • Addinsell
    • 3 yrs ago
    • Reported - view

    In fact that has created a formula field plenty of "Accipiterus" !!

    • Addinsell
    • 3 yrs ago
    • Reported - view

    Hi Fred, it works well I made a mistake…

    Thanks again.

Content aside

  • 3 yrs agoLast active
  • 10Replies
  • 671Views