ICONICO

Discussion Thread

Data Extractor

Message Thread

For WindowsData Extractor

Extract any data, including email addresses and URLs from your files and webpages.

Posted in the Data Extractor Forum.




Extrat data

I have 5000 record in my text file with this format :

[3] 38:wa.mcwilliam@tiscali.co.uk:Washinghton William:NoDataInColumn: &size_id=' + document.enlarged.size_id.value + '&image_url=' + document.enlarged.image_url.value,'my_new_window','toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=yes, width=700, height=700');

How do i to extract so the result only show :

wa.mcwilliam@tiscali.co.uk:Washinghton William

Thank you for the help.
by john a kritko on Dec 26 2008 11:05am Reply

Extrat data

Try adapting the email regular expression rule.
by Ru Menshy on Dec 27 2008 11:11am Reply

Extrat data

Could you please show me the regular expression you mean ?
I'm so sory, i'm not a programmer, i just want to gather some data from my file.
Thank you for your kindness
by john a kritko on Dec 27 2008 3:00pm Reply

Extrat data

Use this
\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*:\w+ \w+
by Nico Westerdale on Dec 27 2008 3:19pm Reply

Extrat data

Thank you westerdale, i''ll try it.
by john a kritko on Dec 27 2008 3:33pm Reply

Extrat data

I have try your advice Westerdale, but the expresion just extract data only with two word.

Ex :
38:wa.mcwilliam@tiscali.co.uk:Washinghton William:
But if the email just have Washinghton, it will not extracted.
Can you help me again Westerdale, or does someone can show me how to extract the data ?

Thank you for the help
by john a kritko on Dec 27 2008 3:48pm Reply

Extrat data

This will extract single names, run it twice.

\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*:\w+

(my name's Nico)
by Nico Westerdale on Dec 27 2008 4:09pm Reply

Extrat data

Thank you Nico.
Your advice help me so much.
by john a kritko on Dec 28 2008 12:06am Reply

Our Software Stores

IconicoAccurate Design and Development Software

BitsDuJourDiscount Deal Coupons for Windows and Mac Software Apps

Our Software Services

SoftwareMarketingResourceYou Wrote the Code, Now How do you Sell it?

IcoBlogOur Official Blog

© copyright 2004-2019 Iconico, Inc. Code & Design. All Rights Reserved. Terms & Conditions Privacy Policy Terms of Use