Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Regular expressions in Format Definition add-on

Hello experts,

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

- I am in search of the right type of regular expression that is used by the Format Definition add-on (javascript, .NET, perl, JAVA, python, etc.)

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.

Former Member
replied

Hello Hendri,

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.

Kind Regards

-Yatsea

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question