Search and Replace

[nevyoung]

I have been doing something similar.  I open the *.gnucash  file and do a
S&R there. Bit tedious but it works. 

 

One of the issues I was having was each time I entered the description  "X
Bank", a previously entered "X Bank Fee" would always be entered. I had to
edit 'fee' part out of the description each time. I would have liked to
replace all previous "X Bank Fee" descriptions with "X Bank".

 

I had some descriptions in initial caps which I decided should rather be in
caps, but there was no way I could get the program to accept the caps - it
automatically changed it to the memorised initial caps format. 

 

Editing the .gnucash file was the only way I could get around these bug.

 

@ John Ralls - It may be that big company auditing and accounting rules do
not allow changes to existing data, but those systems were put in place by
experienced accountants after much planning. I thought that Gnucash was
meant for the home or small business user who certainly would need to change
earlier entries made in error.

 

From: Joseph Hesse [via GnuCash]
[mailto:ml-node+s1415818n4682323h69 at n4.nabble.com] 
Sent: 03 January 2016 16:16
To: nevyoung
Subject: Re: Search and Replace

 

On 01/02/2016 11:02 AM, John Ralls wrote: 


>> On Jan 2, 2016, at 8:38 AM, nevyoung <[hidden email]> 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 
> [hidden email] 
> 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 
[hidden email] 
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. 



  _____  

If you reply to this email, your message will be added to the discussion
below:

http://gnucash.1415818.n4.nabble.com/Search-and-Replace-tp4682277p4682323.ht
ml 

To unsubscribe from Search and Replace, click here
<http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=unsubsc
ribe_by_code&node=4682277&code=bmV2eW91bmdAZ21haWwuY29tfDQ2ODIyNzd8NDkxODcxN
zMw> .
 
<http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=macro_v
iewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.Basi
cNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template
.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_
emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> NAML 





--
View this message in context: http://gnucash.1415818.n4.nabble.com/Search-and-Replace-tp4682277p4682324.html
Sent from the GnuCash - User mailing list archive at Nabble.com.