Search and Replace

[Art]

That's what I do, except I don't export/import.I close GC, dump my SQL database, use SQL commands to do global search & replace. Mostly I do Description, Memo, Notes, but sometimes accounts. The last one is difficult because MySQL doesn't know about the ERD, hence my database backup step! (I corrupted my database several times in the beginning, but I haven't recently. :-> I've learned to be more careful so I wouldn't have to restore the database, wasting 5 minutes, though without the backup, it could be hours.) 
I would not recommend it, unless you're comfortable with SQL and backup & restore of the GC database. 

- Art

      From: Joseph Hesse <joehesse at gmail.com>
 To: gnucash-user at gnucash.org 
 Sent: Sunday, January 3, 2016 6:33 AM
 Subject: Re: Search and Replace
   
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.
Joe
_______________________________________________
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.