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

**URL:** <https://www.dynamicsuser.net/t/is-there-a-find-and-replace-for-a-column/7556>\
**Category:** Developers Forum\
**Created:** [September 5, 2003, 5:17pm UTC](https://www.dynamicsuser.net/t/is-there-a-find-and-replace-for-a-column/7556 "2003-09-05T17:17:26Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Trint](https://avatars.discourse-cdn.com/v4/letter/t/f1d935/32.png) [@Trint](https://www.dynamicsuser.net/u/Trint)\
**Post date:** [September 5, 2003, 5:17pm UTC](https://www.dynamicsuser.net/t/is-there-a-find-and-replace-for-a-column/7556/1 "2003-09-05T17:17:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![stepheng](https://avatars.discourse-cdn.com/v4/letter/s/7feea3/32.png) [@stepheng](https://www.dynamicsuser.net/u/stepheng)\
**Post date:** [September 5, 2003, 5:42pm UTC](https://www.dynamicsuser.net/t/is-there-a-find-and-replace-for-a-column/7556/2 "2003-09-05T17:42:29Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![DjangMan](https://avatars.discourse-cdn.com/v4/letter/d/5e9695/32.png) [@DjangMan](https://www.dynamicsuser.net/u/DjangMan)\
**Post date:** [September 5, 2003, 6:44pm UTC](https://www.dynamicsuser.net/t/is-there-a-find-and-replace-for-a-column/7556/3 "2003-09-05T18:44:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Steffen\_Voel](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@Steffen\_Voel](https://www.dynamicsuser.net/u/Steffen_Voel)\
**Post date:** [September 5, 2003, 7:09pm UTC](https://www.dynamicsuser.net/t/is-there-a-find-and-replace-for-a-column/7556/4 "2003-09-05T19:09:59Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Tirex](https://avatars.discourse-cdn.com/v4/letter/t/6de8d8/32.png) [@Tirex](https://www.dynamicsuser.net/u/Tirex)\
**Post date:** [September 5, 2003, 7:11pm UTC](https://www.dynamicsuser.net/t/is-there-a-find-and-replace-for-a-column/7556/5 "2003-09-05T19:11:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Peter\_Willemse](https://avatars.discourse-cdn.com/v4/letter/p/77aa72/32.png) [@Peter\_Willemse](https://www.dynamicsuser.net/u/Peter_Willemse)\
**Post date:** [September 6, 2003, 3:44pm UTC](https://www.dynamicsuser.net/t/is-there-a-find-and-replace-for-a-column/7556/6 "2003-09-06T15:44:35Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Steffen\_Voel](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@Steffen\_Voel](https://www.dynamicsuser.net/u/Steffen_Voel)\
**Post date:** [September 6, 2003, 4:51pm UTC](https://www.dynamicsuser.net/t/is-there-a-find-and-replace-for-a-column/7556/7 "2003-09-06T16:51:49Z")

</div>

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