| Summary: | Support regexps on imported data | ||
|---|---|---|---|
| Product: | [Applications] skrooge | Reporter: | Karl Ove Hufthammer <karl> |
| Component: | general | Assignee: | Stephane MANKOWSKI <stephane> |
| Status: | RESOLVED FIXED | ||
| Severity: | wishlist | CC: | stephane |
| Priority: | NOR | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | Unlisted Binaries | ||
| OS: | Linux | ||
| Latest Commit: | http://commits.kde.org/skrooge/1d37e460095e59d7a21c5d355263a3a1c57f14b1 | Version Fixed In: | |
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. New URL of QT bug: https://bugreports.qt-project.org/browse/QTBUG-18871 New URL of QT bug: https://bugreports.qt-project.org/browse/QTBUG-18084 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 |
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