www.ritlabs.com [Topic: Export mail to a single line]

Export mail to a single line

Wed, 02 Dec 2009 16:31:02 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
Thank you for your efforts, unfortunately the recursive templates are gibberish to me

Fortunately I found another walkaround - I put in the initial filter that creates this template:

------------
@@@ http://werwerwer

@@@

this part of the text might be on a single line, multiple lines separated

by

any number

of blank lines

~~~dsfsdfsdf~~~
--------------------
another line:
%organization=%REGEXPTEXT="whatever"
(whatever) - the original regex I use to parse the body

This way when exporting the message to the file (using a second manual filter) I have the %organization field holding all the text in one line
02 December 2009 16:31:02, Alex Alex.

Export mail to a single line

Tue, 24 Nov 2009 17:20:21 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
Ouch, I'm afraid that it's a bit over my head to develop a regexp that does this properly.
What you basically need is a regexp that gets the text between your markers. That's the easy part, you had that by yourself.

Next thing would be a recursive template that deletes all intstances of empty lines, it needs to be recursive because you don't know how often those empty lines occur.

Final thing would be a recursive template that replaces all single instances of a line feed into a space, so everything is placed on a single line.

And I'm not that good in recursive templates. You might want to look at the macro library at http://www.silverstones.com/thebat/Library.html It has some good examples of recursive templates.
24 November 2009 17:20:21, Roelof Otten.

Export mail to a single line

Tue, 24 Nov 2009 07:20:13 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
Sorry for not being more specific

Here is how some real text would look like:
-------
@@@ http://werwerwer

@@@

this part of the text might be on a single line, multiple lines separated

by

any number

of blank lines

~~~dsfsdfsdf~~~
-------
or:
-------

@@@http://asd.local/asdasdasd
@@@

hello asdasdaasd,

please notice sldjflsdjflksdf

10 X
sdfsdfsdfs

~~~sdfsdfsdf~~~
--------
or:
--------
@@@ http://ddddddddddddddddddd

@@@

sdfsdfsdfsdfsdf

~~~sdfsdfsdfsd~~~

Thanks!
24 November 2009 07:20:13, Alex Alex.

Export mail to a single line

Mon, 23 Nov 2009 20:40:17 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
Give me real sample of the text you want to process and I'll see whether we can fix that.
My regexp worked on the text you gave as example:
-------------------
asd@
123
678
@ert
-------------------
But in your second post you gave me:
-------------------
@@@unuseful text@@@
line1

line2
~~~unuseful text~~~
-------------------
In the latter case the regexp should look like:"
%SetPattRegExp='(.*)@\n(.*)\n\n(.*)\n~(.*)'%-
%RegExpBlindMatch='%Text'%-
%SubPatt='2' %SubPatt='3'
Note that it's important to know whether the empty line between line1 and line2 is a real empty line or that it may contain a (number of) space(s).
My regexp supposes it's a real empty line.
23 November 2009 20:40:17, Roelof Otten.

Export mail to a single line

Mon, 23 Nov 2009 16:44:10 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
I get nothing (blank when attempting to use this

Thanks!
23 November 2009 16:44:10, Alex Alex.

Export mail to a single line

Mon, 23 Nov 2009 15:03:11 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
When looking at the data you give in the first message, you get the wanteed results with this template:
%SetPattRegExp='(.*)@\n(.*)\n(.*)\n@(.*)'%-
%RegExpBlindMatch='%Text'%-
%SubPatt='2' %SubPatt='3'
Adapt this to your real data.
23 November 2009 15:03:11, Roelof Otten.

Export mail to a single line

Mon, 23 Nov 2009 10:48:28 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
Hey, Unfortunately no luck, adding %wrapped:

%Wapped='%REGEXPTEXT="@@@.*@@@..(.*)~~~.*~~~"'
or
%Wapped='%REGEXPTEXT="@@@.*@@@..(.*)~~~.*~~~"'

returns the exact same string as it did without %wrapped and:

%Wapped="%REGEXPTEXT="@@@.*@@@..(.*)~~~.*~~~""
returns:
=@@@.*@@@..(.*)~~~.*~~~""

Thanks for your help!
23 November 2009 10:48:28, Alex Alex.

Export mail to a single line

Fri, 20 Nov 2009 19:03:39 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.

I meant %Wrapped in stead of %wapped
20 November 2009 19:03:39, Roelof Otten.

Export mail to a single line

Fri, 20 Nov 2009 18:10:19 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
Unfortunately that did not work
Sample text:

@@@unuseful text@@@
line1

line2
~~~unuseful text~~~

I process this with:

%REGEXPTEXT="@@@.*@@@..(.*)~~~.*~~~"

and the output is:

---------
line1

line2
---------

Tried with:
%Wapped='%REGEXPTEXT="@@@.*@@@..(.*)~~~.*~~~"'
but the text in the "Preview" window just disappeared, maybe the syntax is not correct?

tried %wapped="%REGEXPTEXT="@@@.*@@@..(.*)~~~.*~~~""
but I got: @@@.*@@@..(.*)~~~.*~~~""

tried %wapped=%REGEXPTEXT="@@@.*@@@..(.*)~~~.*~~~"
but got a blank output
20 November 2009 18:10:19, Alex Alex.

Export mail to a single line

Fri, 20 Nov 2009 17:31:55 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
I'm not sure whether it wprks, but you could try:
%Wapped='%REGEXPTEXT="@@@(.*)@@@"'
20 November 2009 17:31:55, Roelof Otten.

Export mail to a single line

Fri, 20 Nov 2009 13:43:42 +0200

Export mail to a single line how to export mail body to a single line in forum The Bat! - Templates and Macros.
Hey,

I am trying to export the result of a regex to a text file on a single line, for example:

I have a mail with the body:

asd@
123
678
@ert

I have a manual filter with the "Export to file" option and in its template the regex:
%REGEXPTEXT="@@@(.*)@@@"

This would create in the text file the filter exports to 2 lines

123
678

I am trying to get it to export both lines on a single line and interpret the new line as a single space, the desired output would be:

123 678

How can this be done?

Thank you!
20 November 2009 13:43:42, Alex Alex.