User Name
Password
AppleNova Forums » Programmer's Nook »

I need some regex help


Register Members List Calendar Search FAQ Posting Guidelines
I need some regex help
Thread Tools
ThunderPoit
Making sawdust
 
Join Date: May 2004
Location: Minnesota
 
2014-08-29, 15:47

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
ThunderPoit
Making sawdust
 
Join Date: May 2004
Location: Minnesota
 
2014-08-29, 15:48

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
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Post Reply

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


« Previous Thread | Next Thread »

All times are GMT -5. The time now is 09:21.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004 - 2024, AppleNova