Discussion Thread
Data Extractor
Message Thread

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.
Extrat data
Try adapting the email regular expression rule.
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
Extrat data
Use this
\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*:\w+ \w+
Extrat data
Thank you westerdale, i''ll try it.
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
Extrat data
This will extract single names, run it twice.
\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*:\w+
(my name's Nico)
Extrat data
Thank you Nico.
Your advice help me so much.