Originally Posted By: Howard Bullock
Once you get to your data, you will need a method to validate the data. Speaking strictly from a character matching perspective, I would recommend that you use Regular Expressions to valid the entry as a valid email address format. RegEx functionality is available via COM.

URL of interest: RFC: Regular Expression UDFs


Howard, thankyou for your input. I'm sure by now you have got an idea of my technical expertise, or lack of it, for the more advanced parts of Kix. I have a massive shortfall in knowledge at this level of scripting and honestly believe that I have no right to implement a script I have little or no understanding of. How could I possibly trust the data if I have little or no understanding of how I got it. With that in mind I just envisaged pulling the data out into a file made up of a line of each entry then work with commands such as "instr" etc to produce a final flat file of all entries with an "@" and without spaces and without duplicates. Very crude I know but until I can raise my knowledge base to the level required to utilise UDF's etc then that is all I have to work with. Just trying to be honest rather than being ungrateful ;\)