Regular expressions in Format Definition add-on
I have a question about regular expressions. I am a newbie in regular expressions and I could use some help on this one. I tried some 6 hours, but I can't get solve it myself.
Summary of my problem:
In SAP Business One (patch level 42) it is possible to use bank statement processing. A file (full of regular expressions) is to be selected, so it can match certain criteria to the bank statement file. The bank statement file consists of a certain pattern (look at the attached code snippet).
:61:071222D208,00N026 :86:P 12345678BELASTINGDIENST F8R03782497 $GH $0000009 BETALINGSKENM. 123456789123456 0 1234567891234560 :61:071225C758,70N078 :86:0116664495 REGULA B.V. HELPMESTRAAT 243 B 5371 AM HARDCITY HARD CITY 48772-54314 :61:071225C425,05N078 :86:0329883585 J. MANSSHOT PATTRIOTISLAND 38 1996 PT HELMEN BIJBETA LING VOOR RELOOP RMP1 SET ORDERNR* 69866 / SPOEDIG LEVEREN :61:071225C850,00N078 :86:0105327212 POSE TELEFOONSTRAAT 43 6448 SL S-ROTTERDAM MIJN OR DERNR. 53846 REF. MAIL 21-02
Besides that I need the regular expressions below, so the Format Definition will match the right lines from my bankfile.
- a regular expression that selects lines starting with :61: and line :86: including next lines (if available), so in fact it has to select everything from :86: till :61: again.
- a regular expression that selects the bank account number (position 5-14) from lines starting with :86:
- a regular expression that selects all other info from lines starting with :86: (and following if any), so all positions that follow after the bank account number
I am looking forward to the right solutions, I can give more info if you need any.
Yatsea Li replied
In the "General" Tab, there is a atribute "Repetitive", if yes, it select all lines match the criteria. You may refer to the online help of Format Definition for more information.
Sure, I need you mailaddress. You can find mine in my business card. Thanks.