Making sawdust
Join Date: May 2004
Location: Minnesota
|
I'm going to start out frank: regex drives me nuts. I get how powerful it is and how awesome it could be, but i have never been able to understand it, its all just gibberish to me.
That being said, i need some help to figure out how to make something work. In iBank 5, they completely changed how they do their import rules, they're supposed to be smart and learn, but every time i find myself importing transactions, i keep having to rename stuff repeatedly. They have an advanced option for configuring import rules, but it uses the always user friendly regex and they have zero documentation or support for it. So here is what I am trying to do, if i import a transaction where the memo field looks similar to this: Code:
POS PURCHASE POS PURCHASE TERMINAL 27051701 CUB FOODS #1695 E EAGAN MN XXXX XXXXXXXX 08-2 3-14 5:02 PM and the import rule they create looks like this:Code:
CUB FOODS #[0-9][^\p{L}]*E - POS PURCHASE POS PURCHASE TERMINAL [0-9][^\p{L}]*CUB FOODS #[0-9][^\p{L}]*E EAGAN MN XXXX X+[0-9][^\p{L}]*PM How can i adjust that rule so that anything with the string CUB FOODS will match? |
quote |
Making sawdust
Join Date: May 2004
Location: Minnesota
|
I should also mention that the transaction memos vary greatly depending on which cub foods store i happen to shop at.
|
quote |
Posting Rules | Navigation |
|
Thread Tools | |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find & Replace with regex | ast3r3x | Programmer's Nook | 11 | 2007-08-17 07:17 |