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