Re: [libreoffice-users] Regular Expression

On Wed, 28 May 2014 21:32:17 +1000
Keith Bates <keith@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+unsubscribe@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