Re: [libreoffice-users] Regular Expression

At 21:32 28/05/2014 +1000, Keith Bates wrote:
> 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?

I see this question has already been answered. But an alternative 
technique may be to import the data into a spreadsheet. Transaction 
amounts should surely appear as numbers but any rogue value would 
appear as text. You can spot the difference in a variety of ways:

o Numbers are right-aligned by default, whereas text values are left-aligned.
o View | Value Highlighting (or Ctrl+F8) will colour numbers blue but 
leave text values black.
o In a separate column, enter a formula such as 
=IF(ISNUMBER(Xn);"";"Rogue value!") and fill it down the column.
o Create a visible cell style - perhaps with a coloured background. 
Apply conditional formatting, using "Formula is" and 
NOT(ISNUMBER(Xn)) - applying your new cell style. Use the Format 
Paintbrush to apply this down the column.

I trust this helps.

Brian Barker

PS: What's "Turth", please?


--
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