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
-
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?
-
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
-
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.
-
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)
-
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
-
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…
-
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?
-
-I did it !
-Yes it was written in blue Accipiterus
-
In fact that has created a formula field plenty of "Accipiterus" !!
-
Hi Fred, it works well I made a mistake…
Thanks again.
Content aside
- 3 yrs agoLast active
- 10Replies
- 672Views