Bug 263265 - Support regexps on imported data
Summary: Support regexps on imported data
Status: RESOLVED FIXED
Alias: None
Product: skrooge
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Unlisted Binaries Linux
: NOR wishlist
Target Milestone: ---
Assignee: Stephane MANKOWSKI
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-15 22:59 UTC by Karl Ove Hufthammer
Modified: 2013-01-13 19:19 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Karl Ove Hufthammer 2011-01-15 22:59:52 UTC
Version:           unspecified
OS:                Linux

In the CVS export from my bank, the payee information sometimes includes date, credit card or currency information. Example:

20.12 LERØY MAT AS TORGALM. BERGEN
4111111111111111 02.12 EUR 7,99 PLAY.COM

It would be nice if it was possible to automatically postprocess the imported data – to run regexps on it to remove this information, e.g., to change the above payee information to:

LERØY MAT AS TORGALM. BERGEN
PLAY.COM

It’s easy enough to write regexps for this (e.g., something like ‘s/^\d{2}\.\d{2} //’ for the first example), and it would be nice if Skrooge would support this. Note that it should be possible to add several regexps for each field/column.

Reproducible: Didn't try




OS: Linux (i686) release 2.6.33.7-desktop-2mnb
Compiler: gcc
Comment 1 Stephane MANKOWSKI 2011-03-18 12:48:12 UTC
Hi,

SQLITE driver of QT doesn’t support regular expressions yet.
I opened an incident on QT to add this feature.
http://bugreports.qt.nokia.com/browse/QTBUG-18084

I will implement this behaviour in Skrooge when this request will be closed.
Comment 2 Stephane MANKOWSKI 2012-10-19 07:52:01 UTC
New URL of QT bug:
https://bugreports.qt-project.org/browse/QTBUG-18871
Comment 3 Stephane MANKOWSKI 2012-10-19 07:53:52 UTC
New URL of QT bug:
https://bugreports.qt-project.org/browse/QTBUG-18084
Comment 4 Stephane MANKOWSKI 2013-01-13 19:19:54 UTC
Git commit 1d37e460095e59d7a21c5d355263a3a1c57f14b1 by Stephane Mankowski.
Committed on 13/01/2013 at 19:32.
Pushed by smankowski into branch 'Feature'.

M  +1    -0    CHANGELOG
M  +3    -0    skgbankmodeler/skgruleobject.cpp
M  +3    -12   skgbasemodeler/CMakeLists.txt

http://commits.kde.org/skrooge/1d37e460095e59d7a21c5d355263a3a1c57f14b1