Unfortunately, one bank throws everything except for the date and the amount into a single "description" column. It would still be simpler if they did not include the actual transaction date in that column, as it means the description changes... well... daily. Grrrr....
On Thu, Aug 1, 2013 at 12:27 AM, Brian Barker <[email protected]>wrote: > At 21:35 31/07/2013 -0400, Don Parris wrote: > >> Again, I just need to figure out how to extract that bit from the bank's >> description. Any thoughts on that? >> > > As I mentioned, that depends on the precise possibilities in the bank > data. If the relevant data is always in the same columns of the relevant > records, you can probably extract it using MID(); otherwise you may need to > do a more complicated search through the text. > > > Brian Barker > > > -- > To unsubscribe e-mail to: > users+unsubscribe@global.**libreoffice.org<users%[email protected]> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- D.C. Parris, FMP, Linux+, ESL Certificate Minister, Security/FM Coordinator, Free Software Advocate http://dcparris.net/ <https://www.xing.com/profile/Don_Parris><http://www.linkedin.com/in/dcparris> GPG Key ID: F5E179BE -- To unsubscribe e-mail to: [email protected] 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
