My OS is win 7 prof 64 bit and I have office 365. i have an ASCIi text file which has data in the following format :
James Doe (jDoe@gmail.com);
I want to read this file, line by line,
1. to read until before the ( and then copy and paste to a variable;
2 from ( ... ) to copy the email
3. And then to open a table which has already been created, and append the 1. to a field called Xname; and the 2. to a field called yemail.
4. The end of the line is denoted by ";",
5. and continue processig until the end of the file.
has anyone a sample code that could do something like this or close to it, I would appreciate it. Thank u.