www.ritlabs.com [Topic: Extracting data from inbox]

Extracting data from inbox

Fri, 11 Mar 2011 13:48:37 +0200

Extracting data from inbox in forum The Bat! - Configuring the E-mail Client.

====quote====
hare hare wrote:
Well, i know all my phone numbers are in 'xxx-xxx-xxxx' format, but they arent exactly in the same placement within the message, nor have the same keyword in front of them.

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

I've created small quick template, try to test it:
====code====

%IF:"%_telFirsttime"="":"%-
%_telFirsttime(NIE)%-
%_text='%Text'%-
"%-
%SETPATTREGEXP="(?s)(\d{3}\-\d{3}\-\d{4})([^\d].*)"%-
%REGEXPBLINDMATCH(%_text)%-
%SUBPATT(1)
%_text="%SUBPATT(2)"%-
%IF:"%_text"<>"":"%QINCLUDE(tels)"%-

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

Important - name (handle) of this template is 'tels' (if You want to change it remember about changing %QINCLUDE parameter).

Test this in some messages with telephone numbers (reply, type 'tels' and hit ctrl+space).

To use this template in filter create a filter (in read messages), with condition 'any message', action: export the message (choose a file path and name, will be created) with export format plain text and template
====code====

%QINCLUDE(tels)%-

=============
Mark option "Append to the existing file".

In tab "Options" of this filter mark options "...active" "...for manual refiltering", add hotkey (for example ctrl+shift+1). Mark some messages, press hotkey and...
11 March 2011 13:48:37, K_S.

Extracting data from inbox

Fri, 11 Mar 2011 11:30:38 +0200

Extracting data from inbox in forum The Bat! - Configuring the E-mail Client.
I wouldn't try it, too little chance that it's going to work
11 March 2011 11:30:38, Roelof Otten.

Extracting data from inbox

Fri, 11 Mar 2011 07:25:59 +0200

Extracting data from inbox in forum The Bat! - Configuring the E-mail Client.
Thanks for the prompt response once again.
Well, i know all my phone numbers are in 'xxx-xxx-xxxx' format, but they arent exactly in the same placement within the message, nor have the same keyword in front of them.

Any chance I can still get this going? Let me know. Thanks
11 March 2011 07:25:59, hare hare.

Extracting data from inbox

Thu, 10 Mar 2011 19:24:32 +0200

Extracting data from inbox in forum The Bat! - Configuring the E-mail Client.
Same placement or same keyword in front of the phone number.
But you'll need some regular expressions to extract the phone number, I don't know whether that's an option for you....

How to create templates? In this case trhat would be to create a filter with an export action and there yopu'll find a template button.
10 March 2011 19:24:32, Roelof Otten.

Extracting data from inbox

Thu, 10 Mar 2011 18:56:20 +0200

Extracting data from inbox in forum The Bat! - Configuring the E-mail Client.
Can you please expand a little further on this?
Same format in terms of 'xxx-xxx-xxx'(numbers) or in terms of 'same placement' in every mail?
and how do I create a template?

Thanks again
10 March 2011 18:56:20, hare hare.

Extracting data from inbox

Thu, 10 Mar 2011 09:14:29 +0200

Extracting data from inbox in forum The Bat! - Configuring the E-mail Client.
If those messages have got the same format, you could create a template that extracts the phone number and with that template linked to a (manual) filter you extract whatever info you want.
However if they don't have a format in common then you're out of luck.
10 March 2011 09:14:29, Roelof Otten.

Extracting data from inbox

Thu, 10 Mar 2011 08:47:42 +0200

Extracting data from inbox in forum The Bat! - Configuring the E-mail Client.
I am wondering if there is a way to extract data from inbox?
For example, I have 100 emails that contains 'phone numbers' in them,
is there a macro/script that extract those data from each mail and put them into .txt file?

Please advise. Thanks
10 March 2011 08:47:42, hare hare.