www.ritlabs.com [Topic: Problem with script regex and match ...]

Problem with script regex and match ...

Fri, 17 Jul 2009 22:44:27 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
lemo nico, my email adress: konrad_sz@wp.pl

I think this (or any) forum is not the best place to present templates: sometime empty lines, important spaces or new lines disappears in html.

Please, send me some examples of Your orders, and tell me exactly which fields are optional and how much orders in one mail could be (if more than 10 I would recommend template with a 'loop' macro from XMP or MyMacros plugin).
17 July 2009 22:44:27, K_S.

Problem with script regex and match ...

Fri, 17 Jul 2009 19:21:51 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
K_S!
thanks a lot one more time ♥♥♥♥♥♥♥♥♥♥

I have tried it, it works nearly perfect .
my last problem: I get always some "█" (tabs) ant the invoices look horrible :

first Quantity █x
first Name___xxxxxx
first Reference________xxxxxx
Optionen :
first Price
first reduced
Steuern :_______xxxxxx
first total______xxxxxx Ђ

second Quantity_______x
("_" represent the different distances between the felds).

since I can not put tabs in the template in order to recognise the fields, I do not know how can I get ride of them

Till know I use the folowing template:
%SETPATTREGEXP="(?i-s)^Menge :\s(.*)$|\z"%-%REGEXPBLINDMATCH="%text"%-%SUBPATT="1"%-
in order to get the result of the field "Menge :"

in fact the originality the fields look like:

Menge : 2
Name : Thebat Pro V9
Katalognummer : TBV9
Optionen : Voyager
Preis : 9,50 Ђ
Herabgesetzt auf : 4,50 Ђ
Steuern : 1,44 Ђ
Zwischensumme : 9,00 Ђ

for your info here is the translation German <-> english:
Menge <-> Quantity
Herabgesetzt auf <-> reduced
Steuern <-> Tax
Zwischensumme <-> first total

And I need to get the following result in order to print it in only one page even if 20 products are ordered:

"Menge" "Katalognummer" "Name"
"Optionen (if present)
"Preis" "Herabgesetzt auf" (if present) "Steuern" "Zwischensumme"

2 x TBV9 Thebat Pro V9
Option : Voyager
Preis stück : 9,50 Ђ, Herabgesetzt auf : 4,50 Ђ, inklusive Steuer : 1,44 Ђ, Zwischensumme : 9 ,00 Ђ

so that we don t need 20 pages to print the order

With your template the field "Optionen :" block the template to extract the name of the product...

I would like to send U the Email I get in order to show U how they look like ?

Please write me your Email in your profile (you can use for this http://www.jetable.org/en/index in order to avoid spam) that will give me also the possibility to send U a small "thank U".
17 July 2009 19:21:51, lemo nico.

Problem with script regex and match ...

Wed, 15 Jul 2009 23:02:41 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
Try this regexp:
====code====

%SETPATTREGEXP="(?is)(^Quantity : )(.*?)\n%-
(^Name : )(.*?)\n%-
(^Reference : )(.*?)\n%-
(^Price : )(.*?)\n%-
((^reduced to : )(.*?)\n)?%-
(^total line : )(.*?)\n%-
(.*?\1(.*?)\n\3(.*?)\n\5(.*?)\n\7(.*?)\n(\10(.*?)\n)?\12(.*?)\n)?%-
(.*?\1(.*?)\n\3(.*?)\n\5(.*?)\n\7(.*?)\n(\10(.*?)\n)?\12(.*?)\n)?%-
(.*?\1(.*?)\n\3(.*?)\n\5(.*?)\n\7(.*?)\n(\10(.*?)\n)?\12(.*?)\n)?%-
"%-
%REGEXPBLINDMATCH="%TEXT"%-

first Quantity %SUBPATT(2)
first Name %SUBPATT(4)
first Reference %SUBPATT(6)
first Price %SUBPATT(8)
%IF:'%SUBPATT(9)'<>'':'first reduced %SUBPATT(11)'
first total %SUBPATT(13)

%IF:'%SUBPATT(14)'<>'':'
second Quantity %SUBPATT(15)
second Name %SUBPATT(16)
second Reference %SUBPATT(17)
second Price %SUBPATT(18)
%IF:`%SUBPATT(19)`<>``:`second reduced %SUBPATT(20)`
second total %SUBPATT(21)
'%-

%IF:'%SUBPATT(22)'<>'':'
third Quantity %SUBPATT(23)
third Name %SUBPATT(24)
third Reference %SUBPATT(25)
third Price %SUBPATT(26)
%IF:`%SUBPATT(27)`<>``:`third reduced %SUBPATT(28)`
third total %SUBPATT(29)
'%-

%IF:'%SUBPATT(30)'<>'':'
fourth Quantity %SUBPATT(31)
fourth Name %SUBPATT(32)
fourth Reference %SUBPATT(33)
fourth Price %SUBPATT(34)
%IF:`%SUBPATT(35)`<>``:`fourth reduced %SUBPATT(36)`
fourth total %SUBPATT(37)
'%-

=============

====quote====
Tell me also How can I thank U
=============
No problemo
15 July 2009 23:02:41, K_S.

Problem with script regex and match ...

Wed, 15 Jul 2009 14:51:35 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
oh oh I have talk to fast

in fact with this template I get all the Name

so for my exemple I get

The Bat! Pro Edition V9.9
The Bat! Voyager V9.9
The Bat! Private Disk V9.9

but what is about the other field ?

Quantity :
Reference :
Price :
reduced to :
total line :

?

I suppose we should here mare some other SUBPATT(...)

I have tried to mix the progammation, change the line and so on, but without success

I know it a hard challenge but the possibility of such a template is really a dream !!!

Tell me also How can I thank U, send me your Email for ex. because U R really my saviour
15 July 2009 14:51:35, lemo nico.

Problem with script regex and match ...

Wed, 15 Jul 2009 14:01:25 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
KOOOL !!! KS you are the best !
how can I thank U ????

15 July 2009 14:01:25, lemo nico.

Problem with script regex and match ...

Tue, 14 Jul 2009 17:04:57 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
Lemo nico, I don't understand, in Your first message email format was different and my regexp worked. Maybe there are some spaces (at the begining of the line) or empty lines in real emails?

If e-mails looks like in Your newest message, then a simple template to catch names of products could looks like that (this will catch max 7 names):
====code====

%SETPATTREGEXP="(?is)(^Name :\s)(.*?)\n%-
(.*?\1(.*?)\n)?%-
(.*?\1(.*?)\n)?%-
(.*?\1(.*?)\n)?%-
(.*?\1(.*?)\n)?%-
(.*?\1(.*?)\n)?%-
"%-
%REGEXPBLINDMATCH="%TEXT"%-
%SUBPATT(2)%-
%IF:'%SUBPATT(4)'<>'':' and %SUBPATT(4)'%-
%IF:'%SUBPATT(6)'<>'':' and %SUBPATT(6)'%-
%IF:'%SUBPATT(8)'<>'':' and %SUBPATT(8)'%-
%IF:'%SUBPATT(10)'<>'':' and %SUBPATT(10)'%-
%IF:'%SUBPATT(12)'<>'':' and %SUBPATT(12)'%-
%IF:'%SUBPATT(14)'<>'':' and %SUBPATT(14)'%-

=============
14 July 2009 17:04:57, K_S.

Problem with script regex and match ...

Tue, 14 Jul 2009 13:53:29 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
Roelof Otten!,
K_S!,
I try and retry your proposal, and try also to modify it (I am an inexperienced Templatemaker ) but I only managed to get the first product

In fact I am working with a Webshop and I get the order in emails. I rewrite each order in invoice and lose too much time.
My dream: TheBat get the info and put print it with templates.

The Email looks like that:

Quantity : 2
Name : The Bat! Pro Edition V9.9
Reference : TBP9.9
Price : $45.00
reduced to : $39.00
total line : $78,00

Quantity : 1
Name : The Bat! Voyager V9.9
Reference : TBV9.9
Price : $15.00
reduced to : $9.00
total line : $9.00

Quantity : 1
Name : The Bat! Private Disk V9.9
Reference : TBPD9.9
Price : $19.00
total line : $19.00

I have been trying and trying but without success

Hopping a programming god could help me here
14 July 2009 13:53:29, lemo nico.

Problem with script regex and match ...

Tue, 21 Aug 2007 23:16:10 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
thanks a lot
I try it and say you the way its go
21 August 2007 23:16:10, lemo nico.

Problem with script regex and match ...

Mon, 20 Aug 2007 16:01:33 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
I hate www forums... Code from my previus message is broken. Before each number in %SETPATTREGEXP should be an \\ (backslash).
20 August 2007 16:01:33, K_S.

Problem with script regex and match ...

Mon, 20 Aug 2007 15:52:20 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
I think recursive template is too complicated solution. Regexp is faster. If You have only a few lines with 'Product : sth' in email (for example no more than 10) You could use this regexp:

====code====

%SETPATTREGEXP="(?i-s)(^Product :\s)(.*)(\n|\z)(\1(.*)\3)?(\1(.*)\3)?"%-
%REGEXPBLINDMATCH="%TEXT"%-
%SUBPATT(2)%-
%IF:'%SUBPATT(5)'<>'':' and %SUBPATT(5)'%-
%IF:'%SUBPATT(7)'<>'':' and %SUBPATT(7)'%-

=============

This will catch three 'Product' lines, but I hope You see how it works and know how to expand this.
20 August 2007 15:52:20, K_S.

Problem with script regex and match ...

Fri, 17 Aug 2007 12:40:10 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
I'm a bit short on time currently, so you've got to wait. But maybe somebody else feels like having a go at it.
17 August 2007 12:40:10, Roelof Otten.

Problem with script regex and match ...

Thu, 16 Aug 2007 19:00:52 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.

Hello Roelof Otten,

I have tried, tried, tried but din not managed

The challenge is too big for me
16 August 2007 19:00:52, lemo nico.

Problem with script regex and match ...

Tue, 01 May 2007 13:39:08 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
Thanks a lot for the tip,

I ll try to write the template and inform you about the result (in fact it is a big challenge for me since I am a beginner in QT) .

one more time thanks a lot.
01 May 2007 13:39:08, lemo nico.

Problem with script regex and match ...

Mon, 30 Apr 2007 18:40:29 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
You need a recursive quick template: a template that calls itself.
Without writing the template for you (otherwise there'd be no challenge left for you, would there?) here are some things, you'll need to address for this.
Call your QT SearchForProductItems, that's a nice distinctive name.
Use the %_SFPI_ prefix for all parameters, like %_SFPI_Counter, %_SFPI_Result, %_SFPI_SearchText, %_SFPI_Output, etc. This way you don´t have to take care that you´re using parameters with the same name as the template that calls the first QT.
First thing your template has to do is check whether you´re running it for the first pass or not, that´s why you use a counter. The first pass sets your counter to 1 and sets your searchtext to equal %Text.
Next your QT extracts the first product, enters that value in the Result parameter and sets the the rest of your searchtext as yur new searchtext.
Something like this±
%SetPattRegExp="(?is)Product:\s(.*?)\n(.*)"%-
%RegExpBlindMatch="%_SFPI_SearchText"%-
%_SFPI_Result='%SubPatt="1"'%-
%_SFPI_SearchText='%SubPatt="2"'%-
Now you check whether your result is empty or not. If it's empty then you stop processing the text. If it's not empty then you add the result to your output parameter and call the QT again. As it isn't the first time your QT is called, your counter has a value and so your template will 'know' that you've got a truncated searchtext and will use that.

I hope this makes things a bit clear.
An example of a recursive template can be found here: http://cgi.silverstones.com/library.php#greet_all_recipients

30 April 2007 18:40:29, Roelof Otten.

Problem with script regex and match ...

Mon, 30 Apr 2007 16:26:30 +0300

Problem with script regex and match ... Templates and Macro in forum The Bat! - Templates and Macros.
hello,

I use 100 times a day such a template:
%SETPATTREGEXP="(?i-s)^BProduct :\s(.*)$|\z"%-%REGEXPBLINDMATCH="%text"%-

in order to make automatic answer of my forms like:

Original email from a form:

Contact: Mr beam
Email: beam@blabla.com
Product : book of linux
Product : book of window

My answer is:

Dear Mr beam, please find enclose more information about the book of linux.

And I would like to have:

Dear Mr beam, please find enclose more information about the book of linux and the book of window.

That forI am using a template like
%SETPATTREGEXP="(?i-s)^BProduct :\s(.*)$|\z"%-%REGEXPBLINDMATCH="%text"%-

My problem is: how can I configure my template in order to get the second chain of Product “book of window“, indeed since it has the same name as the first chain “Product :” book of linux I always get only the first regex (book of linux) and I can not get the book of window In my answer.

How do I do this ?

Many thanks in advance.
30 April 2007 16:26:30, lemo nico.