[libreoffice-users] Regular Expression
Hi, I'm in unfamiliar territory, searching a QIF file for a single badly formatted transaction. I've exported the original moneydance file to a tab limited file with the thought of searching for a non-numeric character in the transaction amount column. The only problem is I can't work out the appropriate Reg. Exp to search for characters that are not numeric or a . My brain just refuses to twist into the required contortions to work out regular expressions! Can someone give me the formula required in the Find box in libre office please? Keith Bates New Life Christian Fellowship Ph 02 67924890 Jesus is the Way, the Turth and the Life. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Regular Expression
On Wed, 28 May 2014 21:32:17 +1000 Keith Bates ke...@new-life.org.au wrote: Hi, I'm in unfamiliar territory, searching a QIF file for a single badly formatted transaction. I've exported the original moneydance file to a tab limited file with the thought of searching for a non-numeric character in the transaction amount column. The only problem is I can't work out the appropriate Reg. Exp to search for characters that are not numeric or a . [snip] You want to find everything that's *not* in a particular set, so... [^0-9\.] That's anything that's not zero thru nine or a (literal) dot. Depending upon the flavour of regexp support, that can also be written [^[:digit:]\.] or [^\d\.], but the first one I gave works with any flavour. HTH Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.php. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] [Calc] - Rendering problems /very slowly in 4.2?
Hi :) It might be good to go straight to posting a bug-report https://wiki.documentfoundation.org/QA/BugReport Hopefully that link helps you see if there are already existing reports about it. If there are then just add a comment to one of them instead of starting another report. Version numbers are useful! Then until it gets fixed it's probably best to use Gnumeric. There is no harm with doing that. Although we are competitors we are all one big wider community really and co-operate with each other. There is no problem with using different programs when they all co-operate with each other, as Gnumeric and LibreOffice (and many others) do. When the problem gets fixed just come back to Calc. The only problem is when you have to go back to MS Office or something else that tries to be incompatible with everyone else and LibreOffice mostly handles that fairly well too anyway :) Regards from Tom :) On 28 May 2014 15:04, Miles Prower siabef.deb...@gmail.com wrote: Hi. Sorry for my english. I'll try to write properly. I'm so desperate. On Debian Testing, today an upgrade takes me Libreoffice 4.2... I think... «Oh yeah!»... but... now, I only think «Gnumeric, Gnumeric, I need you unfortunately» :( I work with Calc a lot. With that upgrade, I've one big problem Scrolling the mouse... s slow, and It lets lots of artifacts and rendering problems that makes Calc unusable... And I'm not the only one https://bugs.archlinux.org/task/39474 I used Ubuntu 14.04, Lubuntu 14.04 and Xubuntu 14.04 that have the 4.2 branch, and it happens (and happened) too. I've thinked that it was a Desktop Environment problem, because on Testing (in that time with 4.1) that didn't happen... It happens on 4 PCs with different hardware configuration. So sad... I don't want to use Gnumeric, but... I've no choice :( Other thing is the important regression on the spreadsheet's speed. With 3.000+ rows and tons of numbers, it's 3x slower than 4.1 version... Did anyone of you suffer this annoying problem? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Regular Expression
Brian Barker PS: What's Turth, please? Brian, Thanks for your suggestion. I went with the Reg. Exp method but still unable to find the rogue transaction that throws the error. I could say that Turth is a kind of post-modern rejection of truth, but that would be suggesting that Jesus is not quite the truth. :) I've now fixed the typo as you can see, Keith Bates New Life Christian Fellowship Ph 02 67924890 Jesus is the Way, the Truth and the Life. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Regular Expression
Thanks Jim. That worked, although it didn't solve my problem with the QIF file Keith On Wed, 28 May 2014 08:00:37 AM Jim Seymour wrote: On Wed, 28 May 2014 21:32:17 +1000 Keith Bates ke...@new-life.org.au wrote: Hi, I'm in unfamiliar territory, searching a QIF file for a single badly formatted transaction. I've exported the original moneydance file to a tab limited file with the thought of searching for a non-numeric character in the transaction amount column. The only problem is I can't work out the appropriate Reg. Exp to search for characters that are not numeric or a . [snip] You want to find everything that's *not* in a particular set, so... [^0-9\.] That's anything that's not zero thru nine or a (literal) dot. Depending upon the flavour of regexp support, that can also be written [^[:digit:]\.] or [^\d\.], but the first one I gave works with any flavour. HTH Regards, Jim Keith Bates New Life Christian Fellowship Ph 02 67924890 Jesus is the Way, the Truth and the Life. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
