Search and Replace

[John Ralls]

> On Jan 3, 2016, at 6:33 AM, Joseph Hesse <joehesse at gmail.com> wrote:
> 
> On 01/02/2016 11:02 AM, John Ralls wrote:
>>> On Jan 2, 2016, at 8:38 AM, nevyoung <nevyoung at gmail.com> wrote:
>>> 
>>> Hi - Is there a search and replace function?
>>> I used Quicken for many years but started using Gnucash a year ago. I have
>>> been very disappointed in its ability to bulk search and replace Description
>>> names that were entered incorrectly or need to be changed for some or other
>>> reason.
>>> 
>> No, there is no search-and-replace.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> I don't know if the following would work since I have not tried it. Export your GC data to a MySQL database. Use appropriate SQL statements to make the desired changes. Then import back into GC.

You don't need to export, you can just save as. SQLite3 will work as well in this case and is a lot less effort to set up, especially if you don't have a MySQL server already running.

Regards,
John Ralls