is there a 'find' and 'replace' for a column?

Business Central/NAV Developers Forum
1

In an upgrade, two of our columns in a table were not converted correctly…if i wanted to change ‘P-MV’ in an entire column to ‘O-MV’ is there an easy way or tool to do that? thanks, Trint

2

Hi trint Which Columns on What table do you want to change[?]

3

If those fields are related to a primary key in another table then you can use the rename functionality. Otherwise a codeunit/report could be written to make the change for you. Django

4

You can use normal Windows “Find & Replace”-functionality (Ctrl-H). Place the cursor in the relevant column and go (carefully) ahead.

5

Can’t help MODIFYALL ? example: //here could be some filters - you didn’t need them WITH DO IF FIND(’-’) THEN MODIFYALL(,‘O-MV’);

6

Replace function works fine, however only on cards and not on lists since they are non-editable…

7

I assumed Trint ran the table(s) directly from the Object Designer (this being the Developer Forum).