You’re offline. This is a read only version of the page.
15
In Navision 2016, How can I change same charectors in whole column into other same charectors at the same time.
p.s. in Nav 5.0 we can press ctrl + H to replace
Hi Pamela,
Please accept the answer by Clicking on Yes button, if you feel my comment helped you.
Cheers!
Yes you are correct, in earlier version you had the facility to replace any column values by pressing Ctrl+H, but in Newer version in List page there is no such kind facility available.
So you have to achieve by creating a ProcessingOnly Batch report or go to SQL Server directly and write a replace query as per below syntax (but its not recommended)
UPDATE
table_name
SET
column_name = REPLACE(column_name, 'old_string','new_string')
WHERE
condition;
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (